Create Chart Python Excel

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 Iepazīstiet Aspose.Cells FOSS for Python Oficiālais darbs Darbs ar skropstu. Pārveidošana formātā