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
Metadata
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
|
Security for aspose-cells-python 23.6.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
