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 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 supported 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 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.
Getting Started Limitations and API Differences