DsExcel Java allows users to display aggregated data in a spreadsheet using pivot tables.
A pivot table is a data summarization tool that can perform complex information analytics for the data stored in cells. This facilitates users to explore, analyze and manipulate bulk data in a worksheet.
Inserting pivot tables not only helps in categorizing data in a worksheet but also helps in computing the totals and average of the values in the cells based on the summary functions defined in the built-in functions list.
In order to work with pivot tables in spreadsheets, refer to the the following tasks:
