aspose-cells-python

Try our free online apps demonstrating some of the most popular Aspose.Cells functionality.

A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), CSV, ODS, PDF, JSON, JPG, PNG, BMP, SVG, EMF and HTML files.

Aspsoe.Cells API Features

Aspose.Cells offers a wide arrange of features for creating, reading, manipulating and saving Excel® files:

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.

Supported Read & Write Formats

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

Save Excel® Files As

Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, XPS
Text: JSON, TXT, CSV, TSV, Tab-Delimited, XML
Image: TIFF, PNG, BMP, JPEG, GIF, SVG
Metafile: EMF
Markdown: MD

Create Excel File from scratch using Python

# import the python package
import aspose.cells
from aspose.cells import License, Workbook, FileFormatType

# Create a new Workbook
workbook = Workbook()
# Get the first worksheet
worksheet = workbook.worksheets[0]
# Get the "A1" cell
cells = worksheet.cells
cell = cells.get("A1")
# Write "Hello World" to  "A1" in the first sheet
cell.put_value("Hello World!")
# save this workbook to XLSX
workbook.save("HelloWorld.xlsx")

Convert Excel XLSX File to PDF using Python

# import the python package
import aspose.cells
from aspose.cells import License, Workbook, FileFormatType

workbook = Workbook("bookwithChart.xlsx")
# save this workbook to resultFile,you can see a chart while open the file with MS-Excel*/
workbook.save("Convert.pdf");

Create Excel File and set style for the cells

import aspose.cells as ac
import aspose.pydrawing as ad
from aspose.cells import License, Workbook, FileFormatType

workbook = Workbook()
worksheet = workbook.worksheets[0]
# get cells style
style = worksheet.cells.style
# set font color
style.font.color = ad.Color.green
# set pattern
style.pattern = ac.BackgroundType.GRAY12
# set Background
style.background_color = ad.Color.red
# set Border
style.set_border(ac.BorderType.LEFT_BORDER, ac.CellBorderType.THIN, ad.Color.blue)
style.set_border(ac.BorderType.RIGHT_BORDER, ac.CellBorderType.DOUBLE, ad.Color.gold)
# set string value to cell 'A1'
cells = worksheet.cells
cell = cells.get("A1")
cell.put_value("Text")
# apply style to cell 'A1'
cell.set_style(style)
# save this workbook to resultFile
workbook.save("Style.xlsx")

Release files for aspose-cells-python 23.3.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distributions (wheels)

Table of built distributions (wheels) for aspose-cells-python 23.3.0
File	Interpreter	ABI	Platform	Reset
aspose_cells_python-23.3.0-py3-none-win_amd64.whl 54.5 MB Mar 27, 2023	Python 3	none	Windows x86-64	Details
aspose_cells_python-23.3.0-py3-none-win32.whl 46.9 MB Mar 27, 2023	Python 3	none	Windows x86-32	Details
aspose_cells_python-23.3.0-py3-none-manylinux1_x86_64.whl 75.2 MB Mar 27, 2023	Python 3	none	Linux glibc 2.5+ x86-64	Details

Total release size: 176.5 MB

Release files / aspose_cells_python-23.3.0-py3-none-win_amd64.whl

Download URL	aspose_cells_python-23.3.0-py3-none-win_amd64.whl
Size	54.5 MB
Tags	Python 3 Windows x86-64
SHA-256 checksum How to use checksums	`9d63ea9706ca29a1ad791526ac5f6cc69d28b05841132b8fe34cd128c670ed7c`
BLAKE2b-256 checksum How to use checksums	`44e94625cf565b0cacde565c46010391ec0520e39d9b9bba382f41eb7406dd53`
Upload date	Mar 27, 2023
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.0 CPython/3.10.2`

Release files / aspose_cells_python-23.3.0-py3-none-win32.whl

Download URL	aspose_cells_python-23.3.0-py3-none-win32.whl
Size	46.9 MB
Tags	Python 3 Windows x86-32
SHA-256 checksum How to use checksums	`e72babb5918cd3bf790fbc403d853ee6d7dc5041a033224239d6092abc827918`
BLAKE2b-256 checksum How to use checksums	`5c0c26eb18b6d0e7c4c206b51f5a4171b7aefcbcf9c91977f31006074a9dcfba`
Upload date	Mar 27, 2023
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.0 CPython/3.10.2`

Release files / aspose_cells_python-23.3.0-py3-none-manylinux1_x86_64.whl

Download URL	aspose_cells_python-23.3.0-py3-none-manylinux1_x86_64.whl
Size	75.2 MB
Tags	Linux glibc 2.5+ x86-64 Python 3
SHA-256 checksum How to use checksums	`2dfcfc70626607bb7e25d66af3881efc5c436f72803d8c7cba83ef9a734cec2c`
BLAKE2b-256 checksum How to use checksums	`ba3833e412043aaa34a5fd16fcb1646a0651601a5e9b1ed2a334496c34321c4c`
Upload date	Mar 27, 2023
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.8.0 pkginfo/1.8.2 readme-renderer/34.0 requests/2.27.1 requests-toolbelt/0.8.0 urllib3/1.26.9 tqdm/4.19.5 importlib-metadata/4.8.3 keyring/23.4.1 rfc3986/1.5.0 colorama/0.4.4 CPython/3.6.9`