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.
Important
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. A user can select an operation and click the Run button to view the resulting spreadsheet document in Microsoft Excel.
- Filter Data
- Custom XML parts
- Validate Data in Spreadsheet Cells
- Export a Document to HTML
- Group Data
- Pictures
- Protection
- Search
- Sorting
- Tables
(you will be redirected to DevExpress.com to submit your response)