Aspose.Cells for Python via .NET is a fast and reliable Python API for processing Excel spreadsheets programmatically. It enables developers to create simple or complex spreadsheets, manipulate existing Excel files, and extract data. The API supports reading and writing multiple Excel formats and can render worksheets to XPS, PDF, MHTML, HTML, plain text, and various image formats. It provides a powerful solution to automate Excel report generation in Python applications without requiring Microsoft Excel. Aspose.Cells for Python via .NET supports major Excel formats, fixed‑layout outputs, web formats, text formats, and a wide range of image types. Supported input/output formats include XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML, OTS, ODS, CSV, TSV, JSON, HTML, MHTML, Numbers, SXC, FODS, and EPUB. Export‑only formats include PDF, PDF/A, XPS, DIF, JPEG, PNG, BMP, SVG, TIFF, EMF, GIF, as well as SQL, MARKDOWN, and XHTML. This Python library includes advanced worksheet manipulation features: chart creation, pivot tables, worksheet protection, data formatting, formulas, search and replace, grouping, styling, conditional formatting, page setup customization, and more. It is built with a powerful rendering engine to ensure high‑fidelity output when converting Excel files to PDF, images, or HTML. The API is ideal for enterprise reporting solutions, data transformation, and automation workflows requiring robust Excel capabilities within Python.

Features

• Read Excel Spreadsheets: Open and read Excel files in various formats.
• Render to PDF, EMF & Images: Render worksheets to PDF, EMF, and image formats.
• Worksheet Adjustment: Adjust worksheets inside workbooks.
• Worksheet Protection: Protect or unprotect worksheets.
• Images & Charts: Add images and create charts.
• Pivot Tables & Pivot Charts: Create pivot tables and pivot charts.
• Cell-Level Comments: Add and edit comments at the cell level.
• Search & Replace: Search and replace content within spreadsheets.
• Cell Merging & Splitting: Split and merge cells.
• Grouping: Add or remove grouping for rows and columns.
• Number Formatting: Set number formats for cells.
• Formulas: Read and set formulas.
• Page Setup: Configure page setup settings.
• Orientation & Scaling: Adjust page orientation, scaling, and paper size.
• Conditional Formatting: Read and write conditional formatting rules.
• Excel Format Conversion: Convert Excel files to PDF, XPS, and HTML.
• Flexible Display Options: Control page breaks, zoom, freeze panes, headers/footers, and print area.
• Worksheet Data Management: Manipulate worksheet cells at runtime or import data from external sources.
• Charts Customization: Add standard or customized charts and refresh chart data dynamically.

Benefits

• Python-Based Excel Processing: Perform Excel spreadsheet operations without Microsoft Excel.
• High-Fidelity Export: Convert worksheets to PDF, HTML, and images while maintaining visual accuracy.
• Broad Format Support: Handle a wide range of spreadsheet, text, web, and image formats.
• Enterprise Performance: High-speed processing suitable for large and complex datasets.
• Advanced Formula Engine: Evaluate complex built‑in and custom formulas.
• Flexible Worksheet Configuration: Fine‑tune display settings, page layout, print setup, and data visibility.
• Full Data Control: Edit, search, replace, and format data down to individual cells.
• Rich Visualization: Create and customize charts for professional‑quality reports.