WPF Spreadsheet - Manage Pivot Tables in Code

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.

Files to Review

• 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

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)