WinForms Spreadsheet Pivot Table API
This example demonstrates how to use the SpreadsheetControl Pivot Table API to create and modify pivot tables in code.
The application includes the RichEditControl (at the top) used to display and edit the code and the SpreadsheetControl (at the bottom) which shows the result of code execution.
You can modify the code and watch the result. If an error occurs during compilation or execution, the code window background color turns to pink.
Starting from v2016 vol.1:
- Create calculated fields and calculated items
- Group items in a PivotTable field
- Sort items in a PivotTable field by values of a data field