A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), CSV, ODS, PDF, JSON, JPG, PNG, BMP, EMF, SVG and HTML files.
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
Hashes for aspose_cells_python-24.6.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 83f978a7f4b78f2ae95f6cfb883f757954b15a35ad4f4c06d7d8b2985c2a6d31 |
|
MD5 | ed4792d2c1c1cb146518bc7ddcefa1ad |
|
BLAKE2b-256 | 812558827faee38b59427d4f7bbfc56e19315c0a14763fb38a78d2f4917fb1ac |
Hashes for aspose_cells_python-24.6.0-py3-none-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6ba86c0050d185d290a5e9684c65403a62e7deae6ee6201663e3a6f9f233e202 |
|
MD5 | 5064b0e0939b00112e3a884860c7fa0e |
|
BLAKE2b-256 | ca3d1985ed0e00c50db483d42978801c9b3ded0e74ff06cb074a21bcc4c6a2bb |
Hashes for aspose_cells_python-24.6.0-py3-none-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9565e22f4e9118c97acc4902c607720a9051cb1451a1757b52b2718e57a1ee00 |
|
MD5 | e614143eada5f84ea0dab0bca1dfe656 |
|
BLAKE2b-256 | 919404a819f4dab8edfd86ee5d7797e07a1224533f46ac269b27dc24f475dec5 |
Hashes for aspose_cells_python-24.6.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2b180a8685c9f69b298e0853ac26a5b7af87e9577cfba7b389fc7dd214294975 |
|
MD5 | 1a3d88b77193079a8139584bf9f964a0 |
|
BLAKE2b-256 | 808b717fe0060b79b1bd534592bbd3e2175de8a94a5f80241c41eb0fe3cc3dc8 |
Hashes for aspose_cells_python-24.6.0-py3-none-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 57395cb3cf7fe006a42dfc818288cfeaead906e2d4e40c73924cb510d8702e2a |
|
MD5 | 3ca6e3d95d06734a720048c20ee2eb0d |
|
BLAKE2b-256 | fae6a4bc77ee47f30800b97de4c4873d7787199229f49dd50c322ba011f2f7c9 |