Essential XlsIO supports the creation of pivot tables using simple APIs. The IPivotCache interface caches the data that needs to be summarized. IPivotTable represents a pivot table in object and has properties that allow its customization. The IPivotTables interface returns the PivotTable collection present in a worksheet. IPivotField represents a field in the pivot table. This includes row, column, and data-field axis. IPivotDataFields gets a collection of data fields.

Subtotal

Essential XlsIO also enables the insertion of various subtotal types for the pivot table through the PivotSubtotalTypes enum.

Formatting Pivot Table using Essential XlsIO

Essential XlsIO supports 85 different built-in styles of Excel 2007 and enables users to create tables with rich formatting using a single line of code.

Excel 2007 and Excel 2010 Support

Essential XlsIO is one of the first products to natively support the XLSX file format. Supported features include creating spreadsheets in Excel 2007 and Excel 2010; the advanced features of Excel 2007 and Excel 2010 are also supported, such as conditional formatting representations, pivot tables, and rich 2007 built-in styles.

• XLSX Support
• Cell Styles Support
• Advanced Conditional Formatting
• Tables Support
• Pivot Table