Workbook

Workbook — Aspose.Cells FOSS for Python API Reference

Workbook class je korenski objekat za sve operacije proračunskih tablica u aspose-cells-foss. Upravlja radnim listovima, obrađuje file I/O i pruža pristup svojstvima dokumenta.

: aspose.cells_foss

from aspose.cells_foss import Workbook

Workbook(path=None, password=None)


`path`	`str	None`
`password`	`str	None`

from aspose.cells_foss import Workbook

# Create a new empty workbook
wb = Workbook()

# Open an existing XLSX file
wb = Workbook("report.xlsx")

# Open an AES-encrypted file
wb = Workbook("protected.xlsx", password="secret")


`worksheets`	`WorksheetCollection`		Uređena kolekcija radnih listova. Pristup po indeksu (`wb.worksheets[0]`) ili dodajte putem `wb.add_worksheet(name)`.
`document_properties`	`DocumentProperties`		Osnovni i prilagođeni metapodaci dokumenta (naslov, autor, tema, prilagođeni parovi ključ‑vrednost).

save

wb.save(path, password=None)

Sačuvajte Workbook u fajl. Format izlaza se automatski određuje na osnovu ekstenzije fajla.


`path`	`str`	Odredišna putanja fajla. Koristite `.xlsx`, `.csv`, `.md`, ili `.json` ekstenzija. XLS nije podržan.
`password`	`str	None`

wb.save("output.xlsx")        # XLSX: default format
wb.save("output.csv")         # CSV: first worksheet only
wb.save("protected.xlsx", password="secret")  # encrypted XLSX

save_as_markdown

wb.save_as_markdown(path)

Izvezite prvi radni list kao Markdown tabelu u GitHub stilu.


`path`	`str`	`.md` putanja do fajla.

wb.save_as_markdown("output.md")

add_worksheet

wb.add_worksheet(name=None)

Dodajte novi radni list u Workbook i vratite ga.


`name`	`str	None`

worksheets (WorksheetCollection indeksiranje)


`__getitem__`	`[index: int] -> Worksheet`	Vrati radni list po nultom indeksu. `index`.
`__len__`	`() -> int`	Broj radnih listova u ovoj radnoj svesci.

Primeri upotrebe

Osnovni radni tok Workbook-a

from aspose.cells_foss import Workbook

wb = Workbook()
ws = wb.worksheets[0]
ws.name = "Sales"

ws.cells["A1"].put_value("Quarter")
ws.cells["B1"].put_value("Revenue")
ws.cells["A2"].put_value("Q1")
ws.cells["B2"].put_value(42000)
ws.cells["A3"].put_value("Q2")
ws.cells["B3"].put_value(58000)
ws.cells["B4"].formula = "=SUM(B2:B3)"

wb.save("sales.xlsx")

Dodajte više radnih listova

from aspose.cells_foss import Workbook

wb = Workbook()
wb.worksheets[0].name = "Summary"
ws2 = wb.add_worksheet("Details")
ws3 = wb.add_worksheet("Charts")

print(len(wb.worksheets))   # 3
wb.save("multi-sheet.xlsx")

Otvorite, izmenite i ponovo sačuvajte

from aspose.cells_foss import Workbook

wb = Workbook("existing.xlsx")
ws = wb.worksheets[0]
ws.cells["C1"].put_value("Updated")
wb.save("existing.xlsx")    # overwrite in place

Šifruj pri čuvanju

from aspose.cells_foss import Workbook

wb = Workbook("report.xlsx")
wb.save("report-secure.xlsx", password="MyPassword123")