PIVOT TABLES ARE HERE!
OfficeWriter 8.4 packs a powerful punch with exciting new features, most notable of which is ExcelApplication support for PivotTables in OOXML (XLSX, XLSM) files. ExcelWriter already supports the use of PivotTables in ExcelTemplate and SSRS reports, but now you can programmatically create, manipulate, and remove PivotTables with ExcelApplication.
The new PivotTable API gives you the freedom to:
- Create PivotTables from scratch (see our tutorial on Creating a Basic PivotTable)
- Add and manipulate PivotTable fields – data value fields, column labels, row labels, and report filter page fields
- Access common settings like empty/error values, refresh data when opening a file, and the number of cached items to retain
With the API you also have the ability to change the data source of a PivotTable. Continue reading What’s new in OfficeWriter 8.4