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")

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")

Create a chart

from aspose.cells import Workbook
from aspose.cells.charts import ChartType

# Instantiating a Workbook object
workbook = Workbook()
# Adding a new worksheet to the Excel object
sheetIndex = workbook.worksheets.add()
# Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
# Adding sample values to cells
worksheet.cells.get("A1").put_value(50)
worksheet.cells.get("A2").put_value(100)
worksheet.cells.get("A3").put_value(170)
worksheet.cells.get("A4").put_value(300)
worksheet.cells.get("B1").put_value(160)
worksheet.cells.get("B2").put_value(32)
worksheet.cells.get("B3").put_value(50)
worksheet.cells.get("B4").put_value(40)
# Adding sample values to cells as category data
worksheet.cells.get("C1").put_value("Q1")
worksheet.cells.get("C2").put_value("Q2")
worksheet.cells.get("C3").put_value("Y1")
worksheet.cells.get("C4").put_value("Y2")
# Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
# Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
# Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4"
chart.n_series.add("A1:B4", True)
# Setting the data source for the category data of SeriesCollection
chart.n_series.category_data = "C1:C4"
# Saving the Excel file
workbook.save("Chart.xlsx")

Convert Excel® XLSX File to PDF

#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");

Convert Excel® XLSX File to MD

from aspose.cells import Workbook

# Instantiating a Workbook object
workbook = Workbook()
# Obtaining the reference of the newly added worksheet
sheet = workbook.worksheets[0]
cells = sheet.cells
# Setting the value to the cells
cells.get("A1").put_value("First name")
cells.get("A2").put_value("Simon")
cells.get("A3").put_value("Kevin")
cells.get("A4").put_value("Leo")
cells.get("A5").put_value("Johnson")

cells.get("B1").put_value("Age")
cells.get("B2").put_value(32)
cells.get("B3").put_value(33)
cells.get("B4").put_value(34)
cells.get("B5").put_value(35)

cells.get("C1").put_value("Value")
cells.get("C2").put_value(123.546)
cells.get("C3").put_value(56.78)
cells.get("C4").put_value(34)
cells.get("C5").put_value(9)
# Saving the Excel file to MD
workbook.save("MarkDown.md")

Convert Excel® XLSX File to MD via Stream

import io
from aspose.cells import Workbook, SaveFormat

# Read the input file into a memory stream
with open('HelloWorld.xlsx', 'rb') as file:
    input_stream = io.BytesIO(file.read())

# Create a Workbook object
workbook = Workbook(input_stream)

# Save to a memory stream
out_stream = io.BytesIO()
workbook.save(out_stream, SaveFormat.MARKDOWN)

# Write the memory stream to an output file
with open('HelloWorld.md', 'wb') as f:
    f.write(out_stream.getvalue())

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