Aspose.Cells for Python via Java is a fast and reliable API designed for performing spreadsheet processing tasks directly within Python applications. Developers can create simple or complex spreadsheets, manipulate existing files, and extract data efficiently. The API supports reading and writing multiple Excel formats and offers extensive rendering capabilities to export worksheets to PDF, XPS, MHTML, HTML, plain text, and various image formats. This Python Excel library provides a comprehensive set of features that allow detailed worksheet manipulation, including formatting, formulas, charts, pivot tables, cell-level editing, data search, and more. It is a powerful solution for automating Excel reports using Python without requiring Microsoft Excel to be installed. Supported input and 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, and images such as JPEG, PNG, BMP, SVG, TIFF, EMF, and GIF. The library is optimized for accuracy, performance, and stability.

Features

• Read Excel Spreadsheets: Open and read various Excel file formats.
• Render to PDF, EMF & Images: Render spreadsheets to PDF, EMF, and multiple image formats.
• Worksheet Adjustments: Adjust worksheets inside workbooks.
• Worksheet Protection: Protect and unprotect worksheets.
• Image & Chart Support: Add images and create charts.
• Pivot Tables & Charts: Create pivot tables and pivot charts.
• Cell-Level Comments: Add and edit comments at the cell level.
• Search & Replace: Search and replace data within worksheets.
• Cell Management: Split and merge cells.
• Grouping Controls: Add or remove grouping for rows and columns.
• Number Formatting: Set number formats for cells.
• Formulas: Read and set formulas.
• Page Setup Configuration: Configure page setup options.
• Page Orientation & Paper Size: Adjust page orientation, scaling, and paper dimensions.
• Conditional Formatting: Read and write conditional formatting rules.
• Excel Conversion: Convert Excel files to PDF, XPS, and HTML formats.
• Display Options: Manipulate preview page breaks, zoom level, freeze panes, headers/footers, and print area.
• Worksheet Data Management: Manipulate any cell at runtime or import data from various sources.
• Charts Customization: Add and dynamically update standard or customized charts.

Benefits

• Python-Based Excel Automation: Perform spreadsheet manipulation without Microsoft Excel.
• High-Fidelity Rendering: Export worksheets to PDF, XPS, HTML, and images while preserving design accuracy.
• Broad Format Support: Work with a wide variety of Excel, web, text, and image formats.
• Enterprise-Ready Performance: Fast and reliable engine supports large datasets and complex spreadsheets.
• Advanced Formula Engine: Supports built‑in, add‑in, array, and R1C1 formulas with precise calculation.
• Flexible Worksheet Control: Full page setup control, zoom, print area, orientation, and data visibility settings.
• Data Management Power: Move, edit, search, and format data at the most granular level.
• Rich Visualization: Create and customize charts, graphics, and formatting for professional Excel outputs.