Prezentācija

Aspose.Cells FOSS supports creating charts directly inside Excel .xlsx Šajā bibliotēkā ir 16 dažādi grafiku veidi (līnija, bārs, pi, teritorija, skater, ūdensceļš, kombinācija, krājums, virsma, radari, tri karte, saules, histogramma, funnel, kaste un 화살표 un 지도), un tie visi tiek radīti bez Microsoft Excel instalēšanas.

Karte ir pievienota worksheet.charts.add_*() Kā pieņemt definētu robežlodziņu (upper_left_row, upper_left_column, lower_right_row, lower_right_column) Skaitļu datus pievieno, sērijas datus pievieno chart.n_series.add().

Izveidojiet karti

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")

Līnijas kartes izveidota

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")

Varšava

  • 16 chart types available: Line, Bar, Pie, Area, Scatter, Waterfall, Combo, Stock, Surface, Radar, Treemap, Sunburst, Histogram, Funnel, Box & Whisker, and Map
  • Grafiks tiek izvietots, izmantojot 0 bāzes rindu un kolonnas indexa robežlodziņus.
  • Tādēļ, lai izvairītos no šādām problēmām, ir jāizmanto šādi līdzekļi:"B2:B7")
  • Nav nepieciešama Microsoft Excel, COM automatizācija vai native atkarība.

Izturēties