Spreadsheet Document API – How to Process Excel Workbooks in Code (Part 3)

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:

• Embed arbitrary XML data (custom XML parts) in a spreadsheet document
• Validate data in worksheet cells
• Remove rows and columns that meet a specific condition

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.

Files to Look At

• CustomXmlPartActions.cs (VB: CustomXmlPartActions.vb)
• DataValidationActions.cs (VB: DataValidationActions.vb)
• RowAndColumnActions.cs (VB: RowAndColumnActions.vb)

Documentation

• Custom XML parts
• Validate Data in Spreadsheet Cells
• Remove Rows
• Remove Columns

More Examples

• Spreadsheet Document API - Part 1
• Spreadsheet Document API - Part 2

Does this example address your development requirements/objectives?

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