Spreadsheet Processing Python High Code API

Product Page | Docs | Demos | API Reference | Examples | Blog | Free Support | Temporary License

Aspose.Cells for Python via .NET is a scalable and feature-rich API to process Excel® spreadsheets using Python. API offers Excel® file creation, manipulation, conversion and rendering. Developers can format worksheets, rows, columns or cells to the most granular level, create manipulate chart and pivot tables, render worksheets, charts and specific data ranges to PDF or images, add calculate Excel®'s built-in and custom formulas and much more - all without any dependency on Microsoft Office or Excel® application.

Spreadsheet Python via .NET On-premise API Features

• 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.

Please visit the official documentation for a more detailed list of features.

Read & Write Sreadsheet File Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML
OpenOffice: ODS, SXC, FODS
Text: TXT
Web: HTML, MHTML
iWork®: Numbers
Other: SXC, FODS

Save Spreadsheet Files AS

Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
Meta File: EMF
Markdown: MD

Please visit Supported File Formats for further details.

System Requirements

Your machine does not need to have Microsoft Excel® or OpenOffice® software installed.

Supported Operating Systems

Microsoft Windows®: Windows Desktop & Server (x64, x86)
Linux: Ubuntu, OpenSUSE, CentOS, and others
Other: Any operating system (OS) that can install Mono(.NET 4.0 Framework support) or use .NET core.

Get Started

Installation via pip

The Aspose.Cells for Python via .NET is available at pypi.org. To install it, please run the following command:

pip install aspose-cells-python

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

#Open a existing Workbook
workbook = Workbook("bookwithChart.xlsx")

#save this workbook to PDF file,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 the python package
import aspose.cells as ac
import aspose.pydrawing as ad
from aspose.cells import Workbook,FileFormatType

#Create a new Workbook
workbook = Workbook()
worksheet=workbook.worksheets[0]

#get cell 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 
workbook.save("Style.xlsx")

Product Page | Docs | Demos | API Reference | Examples | Blog | Free Support | Temporary License