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 un CSV
Noklusējuma formāts, saglabājot ar .xlsx paplašinājumu; nododiet SaveFormat.CSV CSV gadījumā:
from aspose.cells_foss import Workbook, Cell, SaveFormat
# Save as XLSX
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")
# Save as CSV
workbook2 = Workbook()
ws2 = workbook2.worksheets[0]
ws2.cells["A1"].value = "Name"
ws2.cells["B1"].value = "Age"
ws2.cells["A2"].value = "Alice"
ws2.cells["B2"].value = 30
ws2.cells["A3"].value = "Bob"
ws2.cells["B3"].value = 25
workbook2.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")
# Output:
# | First name | Age |
# |---|---|
# | Alice | 30 |
# | Bob | 25 |