Skip to main content
Python Software Foundation 20th Year Anniversary Fundraiser  Donate today!

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.

Project description

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, & rendering. Developers can format worksheets, rows, columns or cells to the most granular level, create & manipulate chart & pivot tables, render worksheets, charts and specific data ranges to PDF & images, add & calculate Excel’s builtin and custom formulas and much more - all without any dependency on Microsoft Office or Excel application.

Python Spreadsheet API Features

  • Create Excel files via API.
  • Create & refresh Pivot Tables & charts.
  • Create & manipulate sparklines & conditional formatting.
  • Convert charts to images or PDF.
  • Manage 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.
  • 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
from asposecells.api import Workbook, FileFormatType

workbook = Workbook(FileFormatType.XLSX)
workbook.getWorksheets().get(0).getCells().get("A1").putValue("Hello World")"output.xlsx")


Create Excel Chart & Convert to Image via Python

import jpype
import asposecells
from asposecells.api import Workbook, Chart, ChartType, ImageOrPrintOptions

workbook = Workbook()
sheet = workbook.getWorksheets().get(0)
cells = sheet.getCells()
cells.get(0, 1).putValue("Income")
cells.get(1, 0).putValue("Company A")
cells.get(2, 0).putValue("Company B")
cells.get(3, 0).putValue("Company C")
cells.get(1, 1).putValue(10000)
cells.get(2, 1).putValue(20000)
cells.get(3, 1).putValue(30000)
chartIndex = sheet.getCharts().add(ChartType.COLUMN, 9, 9, 21, 15)
chart = sheet.getCharts().get(chartIndex)
chart.getNSeries().add("B2:B4", True)
aSeries = chart.getNSeries().get(0)
chart.getTitle().setText("Income Analysis")

options = ImageOrPrintOptions()
chart.toImage("chart.png", options)


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

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for aspose-cells, version 21.2.1
Filename, size File type Python version Upload date Hashes
Filename, size aspose-cells-21.2.1.tar.gz (11.0 MB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page