Aspose.Cells FOSS 适用于 Python
使用 Python 创建、修改和导出 Excel 电子表格 — 免费开源，零 Microsoft Office 依赖。
用于 Excel 电子表格的开源 Python 库
Aspose.Cells FOSS for Python 是一个免费、开源的库，用于在 Python 应用程序中处理电子表格文件。只需运行一次 pip install aspose-cells-foss 命令即可安装，并开始创建工作簿、读取单元格、应用样式、构建图表以及导出为 XLSX、CSV、TSV、Markdown 或 JSON，全部无需 Microsoft Excel 或任何 Office 依赖。
该库提供了围绕 Workbook、Worksheet、Cells 和 Cell 构建的简洁、符合 Python 风格的 API，这些对象是每位电子表格开发者熟悉的。使用方括号表示法读取和写入单元格（ws.cells["A1"].value = "Hello"），使用 Font 和 Fill 对象进行样式设置，并通过 ws.charts 上的专用 add_bar() 和 add_line() 方法构建柱状图或折线图。
由于该库不依赖本机 Office 库，可在 Windows、Linux、macOS CI 运行器、Docker 容器以及无服务器环境中实现完全相同的运行效果。markitdown-aspose-cells-plugin 包为 Microsoft 的 MarkItDown 库扩展了 XLSX 支持，使得只需一次调用即可实现工作簿到 Markdown 的完整导出。
Read and Write Excel Files
- XLSX: Open and save workbooks with full round-trip fidelity.
- Cell access: Read and write values with
ws.cells["A1"]bracket notation. - Formulas: Write formula strings stored verbatim in XLSX — evaluated by Excel or LibreOffice on open, not by the library at save time.
- Multiple export formats: Export to CSV, TSV, Markdown, and JSON.
- Round-trip safe: Unknown XML parts are preserved verbatim on re-save.
Where Aspose.Cells FOSS Can Be Used
- Data pipelines: Export database query results directly to XLSX or CSV.
- Report generation: Build styled, branded Excel reports without Office.
- Documentation: Convert spreadsheets to Markdown via the MarkItDown plugin.
- ETL workflows: Read input sheets, transform data, and write output workbooks.
- CI/CD automation: Generate test-result spreadsheets inside Docker containers.
Styling, Charts, and Security
- Font and fill: Apply bold, italic, font size, foreground and background colors.
- Number formats: Set date, currency, and custom number formats per cell.
- Charts: Build bar, line, pie, scatter, area, and combo charts.
- AES encryption: Protect workbooks with a
passwordparameter in one line. - MarkItDown plugin:
markitdown-aspose-cells-pluginadds XLSX export to MarkItDown.
Developer Experience
Aspose.Cells FOSS is installable with a single pip install aspose-cells-foss command. There are no native Office libraries or system packages to install. The library runs on any Python 3.7+ environment without compilation steps.
The API is intentionally small: Workbook, Worksheet, Cells, Cell, Font, Fill, and Chart cover the vast majority of real-world use cases. The codebase is MIT-licensed, hosted on GitHub, and accepts bug reports and pull requests.
Create a Workbook and Write Cells
Install with pip, then create a Workbook, access the first Worksheet, and write values directly to cells using bracket notation. The example also shows how to bold the header row by modifying the cell style before saving.
pip install aspose-cells-foss
from aspose.cells_foss import Workbook
wb = Workbook()
ws = wb.worksheets[0]
# Write values
ws.cells["A1"].value = "Product"
ws.cells["B1"].value = "Revenue"
ws.cells["A2"].value = "Widget"
ws.cells["B2"].value = 42000
# Bold the header row
for col in ["A1", "B1"]:
style = ws.cells[col].get_style()
style.font.bold = True
ws.cells[col].apply_style(style)
wb.save("report.xlsx")
Build a Chart and Export to Multiple Formats
Open the workbook saved above, add a bar chart over a range of rows, then call save() three times with different file extensions — XLSX, Markdown, and CSV — without changing any other code.
from aspose.cells_foss import Workbook
wb = Workbook("report.xlsx")
ws = wb.worksheets[0]
# Add a bar chart over rows 2-10
chart = ws.charts.add_bar(12, 0, 25, 6)
chart.n_series.add("B2:B10", True)
chart.title = "Revenue by Product"
wb.save("report_with_chart.xlsx")
# Export the same workbook to Markdown
wb.save("report.md")
# Or export to CSV
wb.save("report.csv")
常见问题
What is Aspose.Cells FOSS for Python?
It is a free, MIT-licensed Python library for creating, reading, modifying, and exporting Excel spreadsheets without requiring Microsoft Office.
Which file formats are supported?
XLSX for read/write. Export-only formats include CSV, TSV, Markdown (via MarkItDown plugin), and JSON.
Does it require Microsoft Excel or Office?
No. Aspose.Cells FOSS is a pure-Python library with no dependency on Microsoft Office, COM automation, or any proprietary runtime.
How do I install it?
Run pip install aspose-cells-foss. No additional system packages or native extensions are required.
Can I build charts?
Yes. The library supports bar, line, pie, scatter, area, and combo chart types via dedicated chart-builder methods on ws.charts.
Is encryption supported?
Yes. Pass a password parameter when saving to protect the workbook with AES encryption.
What is the MarkItDown plugin?
markitdown-aspose-cells-plugin integrates Aspose.Cells FOSS into Microsoft’s MarkItDown library, enabling full XLSX-to-Markdown conversion with a single call.
Where can I find the source code?
The source code, issue tracker, and contribution guide are available on GitHub under the MIT license.
