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.

Spreadsheet Document API - List of Supported Operations

• Worksheets
• Rows and Columns
• Cells
• Formulas
• Cell Formatting
• Import and Export Data
• Printing
• Specify Document Properties

• Spreadsheet Document API - Part 2

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