This example demonstrates how to use the Spreadsheet Document API to programmatically manage charts in worksheets. The application includes the RichEditControl used to display and edit the code. The code modifies the spreadsheet document loaded into the Workbook instance. To see the results, click the button to open the document in Microsoft Excel.
You can modify the code and watch the result. If an error occurs during compilation or execution, the backcolor of the code window changes.
Note:
The Universal Subscription or an additional Office File API Subscription is required to use this example in production code. Please refer to the following page for pricing information: DevExpress Subscription
- AxesActions.cs (VB: AxesActions1.vb)
- AxesActions1.cs (VB: AxesActions1.vb)
- Charts.cs (VB: Charts1.vb)
- Charts1.cs (VB: Charts1.vb)
- CreationAndDataActions.cs (VB: CreationAndDataActions.vb)
- DataLabelsActions.cs (VB: DataLabelsActions.vb)
- LegendActions.cs (VB: LegendActions.vb)
- Protection.cs (VB: Protection.vb)
- SeriesActions.cs (VB: SeriesActions.vb)
- SparklineActions.cs (VB: SparklineActions.vb)
- StyleActions.cs (VB: StyleActions.vb)
- TitlesActions.cs (VB: TitlesActions.vb)
- TrendlineActions.cs (VB: TrendlineActions.vb)
- ViewOptionsActions.cs (VB: ViewOptionsActions1.vb)
- ViewOptionsActions1.cs (VB: ViewOptionsActions1.vb)