WATERTOWN, MA (February 12, 2013) – SoftArtisans announced the addition of PivotTables to their OfficeWriter product today. OfficeWriter 8.4 is now available for download. Included in this new version, is the ability to create, modify, and remove PivotTables within users’ Excel workbooks. With the new PivotTable functionality customers have the ability to add Report Filters to better filter and sort their data, as well as change the data source of a PivotTable (including PivotTables already copied with CopySheet). This provides users with more fine-grained control over their data and reports.
Also included in this product release are new features to their WordTemplate model. Within WordTemplate DOCX files, users now have the option to programmatically set the document properties of their DOCX files and to remove bookmarked content when delivering reports.
OfficeWriter provides customers Continue reading PivotTables Now Available within OfficeWriter 8.4
Take a walk through of the new PivotTable functionality in the release of OfficeWriter 8.4. To access the new API, download an OfficeWriter Evaluation.
To view a complete list of features and fixes in this release, see What’s New in OfficeWriter 8.4.
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