Contoh Eksport Asas untuk Python
Contoh kod sedia guna untuk mengeksport buku kerja ke XLSX, CSV, dan Markdown dengan Aspose.Cells FOSS untuk Python. Setiap contoh boleh dijalankan secara langsung selepas memasang perpustakaan dengan pip install aspose-cells-foss.
Simpan ke XLSX
Format lalai semasa menyimpan dengan sambungan .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
Eksport data tabular sebagai jadual Markdown — berguna untuk dokumentasi dan penjanaan 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 ialah jadual Markdown standard:
| First name | Age |
|---|---|
| Alice | 30 |
| Bob | 25 |