Membuat diagram dalam file Excel dengan bantuan Python
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 Memperkenalkan Aspose.Cells FOSS untuk Python. Bekerja dengan rumus Lakukan operasi pada tabel Konversi format file
