Python Excel Spreadsheets Parsing APIs

Read Excel Spreadsheets

Render Spreadsheets to PDF, EMF and Images

Adjust worksheets within workbooks

Protect / unprotect worksheets

Add images as well as create charts

Create pivot tables and pivot charts

Add and edit comments at cell level

Search and replace data

Split and merge cells

Add or remove grouping to rows and columns

Set numbers formatting

Read and set formulas

Configure page setup

Adjust page orientation, scaling, paper size

Read & write conditional formatting

Multiple Formats Conversion

Python Excel library provides conversion of Excel files to PDF, XPS & HTML formats. The reliable conversion of API makes it a perfect solution for the companies which require to exchange files in industry-standard formats.

// load file to be converted
Workbook wkbk= new Workbook(SD_PATH + "template.xls");

// Convert XLS to PDF, XPS and HTML
wkbk.save(SD_PATH + "poutput.pdf", SaveFormat.PDF);

wkbk.save(SD_PATH + "xoutput.xps", SaveFormat.XPS);

wkbk.save(SD_PATH + "houtput.html", SaveFormat.HTML);

Flexible Display Options

Aspose.Cells for Python via Java provides full control over page setup allowing to manipulate multiple display options like preview page breaks, set zoom level, set page orientation, control data visibility with freeze panes, paper size, scaling, headers & footers and print area.

Excel Sheets Data Management

Aspose.Cells for Python via Java API provides extensive support for worksheet data management. One can easily manipulate any cell in the worksheet at runtime or import data onto the worksheets from various data sources.

Charts Customization

Aspose.Cells for Python via Java provides full support for charting. One can easily add standard and customized charts or dynamically set chart data in order to refresh the chart vai this python library.