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 23.6.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-23.6.0-py3-none-win_amd64.whl | Python 3 | none | Windows x86-64 | Details |
| aspose_cells_python-23.6.0-py3-none-win32.whl | Python 3 | none | Windows x86-32 | Details |
| aspose_cells_python-23.6.0-py3-none-manylinux1_x86_64.whl | Python 3 | none | Linux glibc 2.5+ x86-64 | Details |
| aspose_cells_python-23.6.0-py3-none-macosx_10_14_x86_64.whl | Python 3 | none | macOS 10.14+ x86-64 | Details |
Total release size: 246.1 MB
Release files / aspose_cells_python-23.6.0-py3-none-win_amd64.whl
| Download URL | aspose_cells_python-23.6.0-py3-none-win_amd64.whl |
|---|---|
| Size | 54.7 MB |
| Tags | Python 3 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
cb75b01a7de5c252a23040bf2d34a34628bfa0cba032aa78bf3ffbcd2ec2fe38
|
|
BLAKE2b-256 checksum How to use checksums |
b61ba6b5d2fe7962abdcc42a4275149cf1e201cbba352601b331ba60cae1e601
|
| 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-23.6.0-py3-none-win32.whl
| Download URL | aspose_cells_python-23.6.0-py3-none-win32.whl |
|---|---|
| Size | 47.1 MB |
| Tags | Python 3 Windows x86-32 |
|
SHA-256 checksum How to use checksums |
9b093d190e8da7f083916454048e523962c16ccd7baa30b93126288fbe2931d0
|
|
BLAKE2b-256 checksum How to use checksums |
ae447e7a5957641b52763ba66b7aa3fa1f8f021a7f5f20dbff7e7b5697cd0f33
|
| 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-23.6.0-py3-none-manylinux1_x86_64.whl
| Download URL | aspose_cells_python-23.6.0-py3-none-manylinux1_x86_64.whl |
|---|---|
| Size | 75.8 MB |
| Tags | Linux glibc 2.5+ x86-64 Python 3 |
|
SHA-256 checksum How to use checksums |
03aba94556ed517cd41005339c0ebfa29fdac568ae80d2e9ff93f951990e1514
|
|
BLAKE2b-256 checksum How to use checksums |
6ef01b438274ec2a36c7fca2b21db5f79c8d144748b5f8c42fa4fea6a3b674f0
|
| 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-23.6.0-py3-none-macosx_10_14_x86_64.whl
| Download URL | aspose_cells_python-23.6.0-py3-none-macosx_10_14_x86_64.whl |
|---|---|
| Size | 68.4 MB |
| Tags | Python 3 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
651e95395d45ec4d59fca86c72b5f66e453a660f552a5e0f5bab2c72207ea59e
|
|
BLAKE2b-256 checksum How to use checksums |
56b26d151f1fe9af99b824dda1296c0aef8bd54c4a3886acfe065b5f0a5f2023
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.10.2
|
