Workbook
Workbook — Aspose.Cells FOSS for Python API Reference
Properties Workbook class 是 aspose-cells-foss 中所有电子表格操作的根对象。它管理工作表，处理文件 I/O，并提供对文档属性的访问。.
Properties: aspose.cells_foss
from aspose.cells_foss import WorkbookProperties
Workbook(path=None, password=None)| Properties | Properties | Properties |
|---|---|---|
path | `str | None` |
password | `str | None` |
Properties:
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")Properties
| Properties | Properties | Properties | Properties |
|---|---|---|---|
worksheets | WorksheetCollection | Properties | 工作表的有序集合。通过索引访问（wb.worksheets[0]）或通过以下方式添加 wb.add_worksheet(name). |
document_properties | DocumentProperties | Properties | 核心和自定义文档元数据（标题、作者、主题、自定义键值对）。. |
Properties
save
wb.save(path, password=None)将工作簿保存到文件。输出格式会根据文件扩展名自动确定。.
| Properties | Properties | Properties |
|---|---|---|
path | str | 目标文件路径。使用 .xlsx, .csv, .md,，或 .json 扩展名。XLS 不受支持。. |
password | `str | None` |
Properties:
wb.save("output.xlsx") # XLSX: default format
wb.save("output.csv") # CSV: first worksheet only
wb.save("protected.xlsx", password="secret") # encrypted XLSXsave_as_markdown
wb.save_as_markdown(path)将第一个工作表导出为 GitHub 风格的 Markdown 表格。.
| Properties | Properties | Properties |
|---|---|---|
path | str | Properties .md 文件路径。. |
wb.save_as_markdown("output.md")add_worksheet
wb.add_worksheet(name=None)向工作簿追加一个新工作表并返回该工作表。.
| Properties | Properties | Properties |
|---|---|---|
name | `str | None` |
worksheets（WorksheetCollection 索引）
| Properties | Properties | Properties |
|---|---|---|
__getitem__ | [index: int] -> Worksheet | 返回基于零索引的工作表 index. |
__len__ | () -> int | 此工作簿中的工作表数量. |
使用示例
基本工作簿工作流
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")添加多个工作表
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")打开、修改并重新保存
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保存时加密
from aspose.cells_foss import Workbook
wb = Workbook("report.xlsx")
wb.save("report-secure.xlsx", password="MyPassword123")