IronXL for Python支援在現代XLSX文件格式中的Excel文件內建立和編輯圖表。
此範例展示如何建立折線圖。 其他圖表型別也受到支援。
如何在Python中建立Excel折線圖
- 安裝IronXL for Python以建立Excel折線圖。
- 載入Excel工作簿並使用
CreateChart建立圖表。 - 將所需的資料值新增到
WorkBook。 - 設定圖表的標題和圖例，然後調用
Plot方法來呈現圖表。 - 將
WorkBook的資料儲存到Excel文件中。
from ironxl import *
# Load the Excel workbook
workbook = WorkBook.Load("test.xlsx")
worksheet = workbook.DefaultWorkSheet
# Set the chart type and its position on the worksheet.
chart = worksheet.CreateChart(ChartType.Line, 10, 10, 18, 20)
# Add the series to the chart
# The first parameter represents the address of the range for the horizontal(category) axis.
# The second parameter represents the address of the range for the vertical(value) axis.
series = chart.AddSeries("B3:B8", "A3:A8")
# Set the chart title.
series.Title = "Line Chart"
# Set the legend position.
# Can be removed by setting it to None.
chart.SetLegendPosition(LegendPosition.Bottom)
# We can change the position of the chart.
chart.Position.LeftColumnIndex = 2
chart.Position.RightColumnIndex = chart.Position.LeftColumnIndex + 3
# Plot all the data that was added to the chart before.
# Multiple calls to this method lead to plotting multiple charts instead of modifying the existing chart.
# Yet there is no possibility to remove a chart or edit its series/position.
# We can just create a new one.
chart.Plot()
# Save changes with the created line chart
workbook.SaveAs("CreateLineChart.xlsx")
