Files to look at:

• AutoFilterActions.cs (VB: AutoFilterActions.vb)
• ExportActions.cs (VB: ExportActions.vb)
• GroupAndOutlineActions.cs (VB: GroupAndOutlineActions.vb)
• PictureActions.cs (VB: PictureActions.vb)
• ProtectionActions.cs (VB: ProtectionActions.vb)
• SearchActions.cs (VB: SearchActions.vb)
• SortActions.cs (VB: SortActions.vb)
• TableActions.cs (VB: TableActions.vb)

This example demonstrates how to use the Spreadsheet Document API to programmatically manage spreadsheet documents, without the need for Microsoft Excel to be installed.
The application includes the RichEditControl  used to display and edit the code. The code modifies the spreadsheet document loaded in 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 backcolor of the code window changes.

This sample introduces API properties and methods used to perform the following operations:

- Insert, delete and modify pictures
- Add a hyperlink to a picture
- Create a table
- Apply a custom style to the table
- Protect a workbook
- Protect a worksheet
- Apply user-specific permissions to a range in a protected worksheet
- Sort a range in descending and ascending orders
- Sort by multiple columns
- Simple search
- Search with options
- Export to HTML
- Group and outline data
- Insert subtotals
- Filter data by a list of values
- Apply a number filter
- Apply a text filter
- Apply a dynamic filter
- Sort the filtered data

For more information, review the Examples section in the documentation.

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.

See also:
Spreadsheet Document API - Part 1

Spreadsheet Document API - Part 3