Aspose.Cells for Python via Java 19.12 Release Notes

File Formats and Conversions

- XLS, SpreadsheetML (XLSX, XML), Comma Separated Value (CSV), HTML, OpenDocument Spreadsheet (ODS), PDF, Tab Delimited, Plain Text (TXT)

Rendering and Printing

- Render spreadsheet to vector images (EMF)

- Render worksheets to raster images (Multipage TIFF, GIF)

- Render worksheets to raster images (PNG, JPEG, etc.)

- Render Spreadsheet to PDF with high fidelity

Spreadsheet Content Features

- Copy or move worksheets within or between workbooks

- Insert images, Create conventional and custom charts and Set gradient background for charts using API

- Add comments to cells

- Microsoft Excel 2007/2010 themes and colors

- Create auto-filters

- Implement data validations

- Implement data sorting

- Find and replace text

- Merge/split Cells

- Group/ungroup rows and columns

- Create custom page breaks

- Calculate complex Excel formulae

- Support advanced conditional formatting supported in Microsoft Excel 2007/2010

- Freeze/unfreeze Panes

- Insert hyperlinks to link data

- Implement Smart Markers

- Specify document properties settings

- Protect/unprotect worksheets

- Specify advanced protection options introduced in Excel XP and later versions

- Create list object/Microsoft Excel tables

- Create subtotals

- Insert form controls and other drawing shapes/objects

- Create pivot tables and pivot charts

- Preserve or remove addin, VBA, macros

- Manipulate named ranges

- Add, preserve or extract OLE objects from the spreadsheets.

- Implement Microsoft Excel sparklines

- Encrypt files

Spreadsheet Formatting Features

- Apply all characters formatting in the cells including fonts, colors, effects, borders, and shading

- Apply all the number format settings (supported in Microsoft Excel) for the cells

- Set all types of text alignment settings

- Apply different kinds of Font Settings for the cells

- Apply different colors to cells, fonts, gridlines, graphic objects, etc.

- Apply different rich text formatting in a single cell

- Apply different border settings on cells

- Apply different background patterns on cells

- Apply Format settings on a worksheet, row, column or a range of cells, etc.

PageSetup Features

- Adjust your page orientation, scaling, paper size

- Specify your margins and page centering

- Create or edit your header and/or footer

- Set print area, print titles, or turn on gridlines, etc.