Product Page | Docs | API Reference | Demos | Blog | Code Samples | Free Support | Temporary License | EULA
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")Product Page | Docs | API Reference | Demos | Blog | Free Support | Temporary License | EULA
2 maintainers
Release files for aspose-cells-python 24.4.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distributions (wheels)
| File | Reset | |||
|---|---|---|---|---|
| aspose_cells_python-24.4.0-py3-none-win_amd64.whl | Python 3 | none | Windows x86-64 | Details |
| aspose_cells_python-24.4.0-py3-none-win32.whl | Python 3 | none | Windows x86-32 | Details |
| aspose_cells_python-24.4.0-py3-none-manylinux1_x86_64.whl | Python 3 | none | Linux glibc 2.5+ x86-64 | Details |
| aspose_cells_python-24.4.0-py3-none-macosx_11_0_arm64.whl | Python 3 | none | macOS 11.0+ ARM64 | Details |
| aspose_cells_python-24.4.0-py3-none-macosx_10_14_x86_64.whl | Python 3 | none | macOS 10.14+ x86-64 | Details |
Total release size: 313.7 MB
Release files / aspose_cells_python-24.4.0-py3-none-win_amd64.whl
| Download URL | aspose_cells_python-24.4.0-py3-none-win_amd64.whl |
|---|---|
| Size | 55.5 MB |
| Tags | Python 3 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
2bfaf6e18b948f6e75e5d3c640959d32f2cc953326d6f9564dd1110ed17ca4e1
|
|
BLAKE2b-256 checksum How to use checksums |
f3a864abb8bfcc2b0da4769eacf383b4a45b7e84d7679f945f8088055316e8c0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.10.2
|
Release files / aspose_cells_python-24.4.0-py3-none-win32.whl
| Download URL | aspose_cells_python-24.4.0-py3-none-win32.whl |
|---|---|
| Size | 47.8 MB |
| Tags | Python 3 Windows x86-32 |
|
SHA-256 checksum How to use checksums |
473532647fd6f458754984faefd63af4cb060f897d20d82421e7fc34f611d7b3
|
|
BLAKE2b-256 checksum How to use checksums |
c940e1a6ed671e5b0cb6ee98f8c09a89aa2c7997559d0c7c75a8ae0d740e28ed
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.10.2
|
Release files / aspose_cells_python-24.4.0-py3-none-manylinux1_x86_64.whl
| Download URL | aspose_cells_python-24.4.0-py3-none-manylinux1_x86_64.whl |
|---|---|
| Size | 77.0 MB |
| Tags | Linux glibc 2.5+ x86-64 Python 3 |
|
SHA-256 checksum How to use checksums |
a73b8e91d43a4438ba512f0ccaeed6c15aed1bb37a69b43cb816323fae999ab8
|
|
BLAKE2b-256 checksum How to use checksums |
da4318f637172b513339d7318132821828e351e25297997ac32a228270b9fb08
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.10.2
|
Release files / aspose_cells_python-24.4.0-py3-none-macosx_11_0_arm64.whl
| Download URL | aspose_cells_python-24.4.0-py3-none-macosx_11_0_arm64.whl |
|---|---|
| Size | 57.8 MB |
| Tags | Python 3 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
07a312e247e9df67db05fb003cc6520e774c1a969642035cd567bf4e9136f67f
|
|
BLAKE2b-256 checksum How to use checksums |
01bcb9bb7b7d654aa80c2612eedc4ae2779b22dcee7010f636e1053157c1cb08
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.10.2
|
Release files / aspose_cells_python-24.4.0-py3-none-macosx_10_14_x86_64.whl
| Download URL | aspose_cells_python-24.4.0-py3-none-macosx_10_14_x86_64.whl |
|---|---|
| Size | 75.6 MB |
| Tags | Python 3 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
f597184050b159d3655535aa07f311e3e5a7e0ca9dccb42edac1e87fdb004fa4
|
|
BLAKE2b-256 checksum How to use checksums |
73d23a793a7f832d968154bfd6cef3d2a3563dd11fb707d0c59b76f885f62211
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.10.2
|
