Features

On a web server or the Windows desktop, ExtremeML is the easiest way to programmatically create and edit rich Excel spreadsheet content using the OpenXML file format.

While the ExtremeML API continues to evolve at a rapid rate, it is already possible to achieve astonishing results using its existing feature set. If a feature you need doesn’t appear to be in the list below, please take a minute to read about the importance of templates, which are central to achieving the ultimate with the minimum of code.

Alternatively, please contact us – we will be happy to advise you whether ExtremeML is able to rise to your challenge.

General Features

  • 100% developed in managed code (C#)
  • Easy deployment of a single DLL
  • Compatible with all environments supported by the OpenXML SDK
  • Fully documented (extensive User Guide and complete API Reference)
  • Fully supported
  • Source code available on CodePlex
  • Open-source licensing under GPL v.2
  • Royalty-free runtime distribution

Core Package Editing Features

  • Open existing or create new workbooks
  • Read and write to / from a stream
  • Insert, delete, rename worksheets
  • Insert and delete rows and columns
  • Set and read strongly-typed cell values
  • Set and read cell formulas
  • Set and read hyperlinks
  • Set and read worksheet cell comments
  • Store images in worksheet cells (under development)
  • Store images in worksheet comments
  • Use rich text in cell values (under development)
  • Use rich text in cell comments
  • Set and read worksheet headers and footers

Support for Table-based Data

  • Populate a table in a single method call
  • Fill a table from a variety of data sources
  • Map table columns directly to a data source
  • Map table column comments to a data source

Features Supported Through Templates

  • Full support for named ranges
  • Full support for Excel 2007 tables
  • Define PivotCharts and PivotTables
  • Full support for styling and themes
  • Full group and outline support
  • Conditional formatting
  • Merged cells
  • Document properties

Planned Enhancements

  • Explicit row and column grouping
  • Explicit cell merging/li>
  • Explicit control of document properties
  • Document merging
  • Explicit use of styling and themes
  • Support for macros
  • Support for Excel 2010 new features