Spreadsheet Processing Python High Code API

Product Page | Docs | Demos | API Reference | Examples | Blog | Free Support | Temporary License

Aspose.Cells for Python via Java is a scalable and feature-rich API to process Excel® spreadsheets using Python. API offers Excel® file creation, manipulation, conversion and rendering. Developers can format worksheets, rows, columns or cells to the most granular level, create manipulate chart and pivot tables, render worksheets, charts and specific data ranges to PDF or images, add calculate Excel®'s built-in and custom formulas and much more - all without any dependency on Microsoft Office or Excel® application.

Spreadsheet Python via Java On-premise API Features

• Spreadsheet generation & manipulation via API.
• High-quality file format conversion & rendering.
• Print Microsoft Excel® files to physical or virtual printers.
• Combine, modify, protect, or parse Excel® sheets.
• Apply worksheet formatting.
• Configure and apply page setup for the worksheets.
• Create & customize Excel® charts, Pivot Tables, conditional formatting rules, slicers, tables & spark-lines.
• Convert Excel® charts to images & PDF.
• Convert Excel® files to various other formats.
• Formula calculation engine that supports all basic and advanced Excel® functions.

Please visit the official documentation for a more detailed list of features.

Read & Write Sreadsheet File Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML
OpenOffice: ODS, SXC, FODS
Text: TXT
Web: HTML, MHTML
iWork®: Numbers
Other: SXC, FODS

Save Spreadsheet Files AS

Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
Meta File: EMF
Markdown: MD

Please visit Supported File Formats for further details.

System Requirements

Your machine does not need to have Microsoft Excel® or OpenOffice® software installed.

Supported Operating Systems

Microsoft Windows®: Windows Desktop & Server (x64, x86)
Linux: Ubuntu, OpenSUSE, CentOS, and others
Other: Any operating system (OS) that can install Java 1.8 or higher, Python 3.5 or higher.

Get Started

Installation via pip

The Aspose.Cells for Python via Java is available at pypi.org. To install it, please run the following command:

pip install aspose-cells

Create Excel® File from scratch using Python

#import the python package
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook

#Create a new Workbook
workbook = Workbook()

#Get the first worksheet
worksheet=workbook.getWorksheets().get(0)

#Get the "A1" cell
cells=worksheet.getCells()
cell=cells.get("A1")

#Write "Hello World" to  "A1" in the first sheet
cell.setValue("Hello World!")

#save this workbook to XLSX 
workbook.save("HelloWorld.xlsx")

jpype.shutdownJVM()

Convert Excel® XLSX File to PDF using Python

#import the python package
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook

#Open a existing Workbook
workbook = Workbook("bookwithChart.xlsx")

#save this workbook to PDF file,you can see a chart while open the file with MS Excel®*/
workbook.save("Convert.pdf");

jpype.shutdownJVM()

Product Page | Docs | Demos | API Reference | Examples | Blog | Free Support | Temporary License