Features

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 the API
• Add comments to cells
• Microsoft Excel 2007 and later versions' 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 available in Microsoft Excel 2007 and later versions
• 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 objects/Microsoft Excel tables
• Create subtotals
• Insert form controls and other drawing shapes/objects
• Create pivot tables and pivot charts
• Preserve or remove add‑in, 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 character 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.

Page Setup 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.