aspose-cells-python 23.11.1

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

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