Features

File Formats and Conversions

  • XLS, SpreadsheetML (XLSX, XML),XLSB, XLSM, DOCX, PPTX, JSON, Comma Separated Value (CSV), HTML, OpenDocument Spreadsheet (ODS), PDF, Tab Delimited, Plain Text (TXT) and popular image formats including TIFF, JPG, PNG, BMP, and SVG.

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 Developer Guide