Skip to main content

Aspose.Cells for Python via Java is a high-performance library that unleashes the full potential of Excel in your Python projects. It can be used to efficiently manipulate and convert Excel and spreadsheet formats including XLS, XLSX, XLSB, ODS, CSV, and HTML - all from your Python code. Amazingly, it also offers free support.

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 Excel 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, JSON Web: HTML, MHTML

Save Excel Files As

Fixed Layout: PDF, XPS Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF Text: CSV, Tab-Delimited, JSON, SQL, XML

Create Excel File from Scratch using Python

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

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

jpype.shutdownJVM()

Convert Excel XLSX File to PDF using Python

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

workbook = Workbook("example.xlsx")
saveOptions = PdfSaveOptions()
saveOptions.setOnePagePerSheet(True)
workbook.save("example.pdf", saveOptions)

jpype.shutdownJVM()

Create Excel Chart & Convert to Image via Python

import jpype
import asposecells
jpype.startJVM()
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)
chart.getNSeries().setCategoryData("A2:A4")
aSeries = chart.getNSeries().get(0)
aSeries.setName("=B1")
chart.setShowLegend(True)
chart.getTitle().setText("Income Analysis")

options = ImageOrPrintOptions()
options.setHorizontalResolution(300)
options.setVerticalResolution(300)
chart.toImage("chart.png", options)

jpype.shutdownJVM()

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.

Source Distribution

aspose_cells-25.6.0.tar.gz (15.3 MB view details)

Uploaded Source

Built Distribution

aspose_cells-25.6.0-py3-none-any.whl (15.2 MB view details)

Uploaded Python 3

File details

Details for the file aspose_cells-25.6.0.tar.gz.

File metadata

  • Download URL: aspose_cells-25.6.0.tar.gz
  • Upload date:
  • Size: 15.3 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.9.12

File hashes

Hashes for aspose_cells-25.6.0.tar.gz
Algorithm Hash digest
SHA256 6a403b9cc7b7d8d1d43530cfad22696e8a50f04ad9ecdd4ac33fa3aff8e671bd
MD5 4ec9625a2d3c404ebd2d94d42b048792
BLAKE2b-256 4311e80adc61b4072690d91347e2177495814cf952fef131f8cf54cfd34fb0ae

See more details on using hashes here.

File details

Details for the file aspose_cells-25.6.0-py3-none-any.whl.

File metadata

  • Download URL: aspose_cells-25.6.0-py3-none-any.whl
  • Upload date:
  • Size: 15.2 MB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.9.12

File hashes

Hashes for aspose_cells-25.6.0-py3-none-any.whl
Algorithm Hash digest
SHA256 f927e8b20f239a616c67dec0bd3b256f7f00c61b33ef4999045926acdc2a1e14
MD5 492743d1ecaaf2d4469c434dfcbfe11d
BLAKE2b-256 f1a50e07df84d2777c74c2ffc735282af1bc56a6e8a686700f9dbc54d5ec05c3

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page