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

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.

Files to Look At

• CellActions.cs (VB: CellActions.vb)
• DocumentPropertiesActions.cs (VB: DocumentPropertiesActions.vb)
• ExportActions.cs (VB: ExportActions.vb)
• FormattingActions.cs (VB: FormattingActions.vb)
• FormulaActions.cs (VB: FormulaActions.vb)
• ImportActions.cs (VB: ImportActions.vb)
• PrintingActions.cs (VB: PrintingActions.vb)
• RowAndColumnActions.cs (VB: RowAndColumnActions.vb)
• WorksheetActions.cs (VB: WorksheetActions.vb)

Documentation

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

More Examples

• Spreadsheet Document API - Part 2
• Spreadsheet Document API - Part 3