Pendahuluan

Aspose.Cells FOSS supports creating charts directly inside Excel .xlsx File yang berasal dari Python. Direktori berisi 16 jenis diagram (Line, Bar, Pie, Area, Scatter, Waterfall, Combo, Stock, Surface, Radar, Treemap, Sunburst, Histogram, Funnel, Box & Whisker, dan Map), semuanya dapat dihasilkan tanpa menginstal Microsoft Excel.

Diagram yang digunakan worksheet.charts.add_*() Metode-metode yang menentukan kerangka batas yang ditentukan (upper_left_row, upper_left_column, lower_right_row, lower_right_column) Indeks berbasis nol… chart.n_series.add().

Buat diagram kolom

from aspose.cells_foss import Workbook

workbook = Workbook()
worksheet = workbook.worksheets[0]

# Write data
months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun"]
sales  = [100, 150, 120, 180, 200, 170]
for i, (m, s) in enumerate(zip(months, sales), 2):
    worksheet.cells[f"A{i}"].value = m
    worksheet.cells[f"B{i}"].value = s

# Add a bar chart anchored to rows 0-20, columns 4-12
chart = worksheet.charts.add_bar(0, 4, 20, 12)
chart.title = "Monthly Sales"
chart.n_series.add("B2:B7", category_data="A2:A7", name="Sales")

workbook.save("bar_chart.xlsx")

Buat diagram garis

from aspose.cells_foss import Workbook

workbook = Workbook()
worksheet = workbook.worksheets[0]

months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun"]
sales  = [100, 150, 120, 180, 200, 170]
for i, (m, s) in enumerate(zip(months, sales), 2):
    worksheet.cells[f"A{i}"].value = m
    worksheet.cells[f"B{i}"].value = s

# Line chart anchored to rows 0-20, columns 4-12
chart = worksheet.charts.add_line(0, 4, 20, 12)
chart.title = "Monthly Sales"
chart.n_series.add("B2:B7", category_data="A2:A7", name="Sales")

workbook.save("line_chart.xlsx")

Poin utama

  • 16 chart types available: Line, Bar, Pie, Area, Scatter, Waterfall, Combo, Stock, Surface, Radar, Treemap, Sunburst, Histogram, Funnel, Box & Whisker, and Map
  • Grafik ditanamkan dalam kerangka yang berbasiskan nol, yang berarti pembatasan indeks baris dan kolom.
  • Seri data dan pengidentifikasi pengurutan dapat didefinisikan menggunakan string bidang mirip Excel ("B2:B7")
  • Microsoft Excel, otomatisasi COM, atau dependensi native tidak diperlukan..

Lihat juga