Spreadsheet Document API - Manage Pivot Tables in Code

This example demonstrates how to use the Spreadsheet Document API to create and modify pivot tables in code.
The application uses the RichEditControl to display and edit the code. The code modifies the spreadsheet document loaded into the Workbook instance. To see the results, open the document in Microsoft Excel by clicking the button.
You can modify the code and watch the result. If an error occurs during compilation or execution, the background color of the code window changes.

The Universal Subscription or an additional Office File API Subscription is required to use this example in production code. Please refer to the DevExpress Subscription page for pricing information.

Files to Look At:

• PivotCalculatedFieldActions.cs (VB: PivotCalculatedFieldActions.vb)
• PivotCalculatedItemActions.cs (VB: PivotCalculatedItemActions.vb)
• PivotFieldActions.cs (VB: PivotFieldActions.vb)
• PivotFieldGroupingActions.cs (VB: PivotFieldGroupingActions.vb)
• PivotTableActions.cs (VB: PivotTableActions.vb)
• PivotTableFilterActions.cs (VB: PivotTableFilterActions.vb)
• PivotTableFormattingActions.cs (VB: PivotTableFormattingActions.vb)
• PivotTableLayoutActions.cs (VB: PivotTableLayoutActions.vb)
• ValueFieldSettingsActions.cs (VB: ValueFieldSettingsActions.vb)

Documentation

• Spreadsheet Pivot Tables
• Pivot Table Examples