Contoh Ekspor Dasar untuk Python
Contoh kode siap pakai untuk mengekspor workbook ke XLSX, CSV, dan Markdown dengan Aspose.Cells FOSS untuk Python. Setiap contoh dapat dijalankan langsung setelah menginstal perpustakaan dengan pip install aspose-cells-foss.
Simpan ke XLSX
Format default saat menyimpan dengan ekstensi .xlsx:
from aspose.cells_foss import Workbook, Cell
workbook = Workbook()
ws = workbook.worksheets[0]
ws.cells["A1"].value = "Product"
ws.cells["B1"].value = "Revenue"
ws.cells["A2"].value = "Widget A"
ws.cells["B2"].value = 12500
ws.cells["A3"].value = "Widget B"
ws.cells["B3"].value = 8750
workbook.save("report.xlsx")Simpan ke CSV
from aspose.cells_foss import Workbook, Cell, SaveFormat
workbook = Workbook()
ws = workbook.worksheets[0]
ws.cells["A1"].value = "Name"
ws.cells["B1"].value = "Age"
ws.cells["A2"].value = "Alice"
ws.cells["B2"].value = 30
ws.cells["A3"].value = "Bob"
ws.cells["B3"].value = 25
workbook.save("data.csv", SaveFormat.CSV)Simpan ke Markdown
Ekspor data tabular sebagai tabel Markdown — berguna untuk dokumentasi dan pembuatan README:
from aspose.cells_foss import Workbook, Cell
workbook = Workbook()
ws = workbook.worksheets[0]
ws.cells["A1"].value = "First name"
ws.cells["B1"].value = "Age"
ws.cells["A2"].value = "Alice"
ws.cells["B2"].value = 30
ws.cells["A3"].value = "Bob"
ws.cells["B3"].value = 25
workbook.save_as_markdown("data.md")Output adalah tabel Markdown standar:
| First name | Age |
|---|---|
| Alice | 30 |
| Bob | 25 |