aspose-cells 19.12.1

Python API to read, write, manipulate & convert Microsoft Excel® files without any dependency. Create & manipulate Workbooks, Worksheets, Pivot Tables, Charts, Sparklines, Conditional Formatting & more. Convert Excel to PDF, XPS, HTML, images & metafiles.

Python Excel File Format API

Aspose.Cells for Python via Java is a scalable and feature-rich API to process Excel spreadsheets using Python. API offers Excel file format conversion, worksheets styling to the most granular level, chart creation & rendering, reliable formula calculation engine and much more.

Python Spreadsheet API Features

• Create Pivot Tables, charts, sparklines & conditional formatting.
• Refresh existing charts & convert charts to images or PDF.
• Create & manipulate comments & hyperlinks.
• Set complex formulas & calculate results via API.
• Set protection on workbook, worksheet, cell, column or row.
• Create & manipulate named ranges.
• Populate worksheets through Smart Markers.
• Manipulate & refresh Pivot Tables via API.
• Convert worksheets to PDF, XPS & SVG formats.
• Inter-convert files to popular Excel formats.

Read & Write Excel Files

Microsoft Excel: XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML OpenOffice: ODS Text: CSV, Tab-Delimited, TXT Web: HTML, MHTML

Save Excel Files As

Fixed Layout: PDF, XPS Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF

Create Excel File from Scratch using Python

import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook, FileFormatType

wb = Workbook(FileFormatType.XLSX)
wb.getWorksheets().get(0).getCells().get("A1").putValue("testing...")
wb.save("wb.xlsx")

jpype.shutdownJVM()

Product Page | Documentation | Blog | API Reference | Code Samples | Free Support | Temporary License | EULA