Python pamata eksporta piemēri
Gatavie koda piemēri darba grāmatu eksportēšanai uz XLSX, CSV un Markdown, izmantojot Aspose.Cells FOSS for Python. Katru piemēru var izpildīt tieši pēc bibliotēkas instalēšanas ar pip install aspose-cells-foss.
Saglabāt kā XLSX
Noklusējuma formāts, saglabājot ar .xlsx paplašinājumu:
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")Saglabāt 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)Saglabāt kā Markdown
Eksportēt tabulārus datus kā Markdown tabulas — noderīgi dokumentācijas un README ģenerēšanai:
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")Izvade ir standarta Markdown tabula:
| First name | Age |
|---|---|
| Alice | 30 |
| Bob | 25 |