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:
- Manage spreadsheet document elements (worksheets, cells, rows, and columns)
- Create formulas
- Format cells
- Import data from different data sources
- Export a workbook to PDF
- Print a workbook
- Specify the built-in and custom document properties
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.
- Worksheets
- Rows and Columns
- Cells
- Formulas
- Cell Formatting
- Import and Export Data
- Printing
- Specify Document Properties
(you will be redirected to DevExpress.com to submit your response)
