The DevExpress Spreadsheet Document API is a non-visual library that allows you to generate, import, export, modify, and print Microsoft Excel workbooks in code.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this library in production code.
This example demonstrates how to use the Spreadsheet Document API to execute the following actions:
- Apply filters to a worksheet range (a dynamic filter, the “Top 10” filter, number, text, and date filters)
- Save a worksheet in HTML format
- Group and ungroup worksheet rows and columns
- Outline worksheet data automatically
- Create subtotals for a cell range
- Insert a picture into a worksheet and modify an embedded picture
- Protect and unprotect a workbook or a worksheet
- Protect specific worksheet ranges
- Sort data in a range
- Manage tables and table styles
- Search for specific data in a worksheet
The application form contains the list of supported operations and the editor that allows you to view and edit the source code for each operation. Select an operation, modify its code if necessary, and click Open in Microsoft Excel to open the resulting spreadsheet document in Microsoft Excel. If an error occurs during compilation or execution, the background color of the code editor changes to pink.
- 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)
(you will be redirected to DevExpress.com to submit your response)