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)
This example demonstrates how to use the Spreadsheet Document API to programmatically manage spreadsheet documents, without the need for Microsoft Excel to be installed.
In particular, this sample introduces API properties and methods used to perform the following operations:
- Manage worksheets (activate, create, delete, rename, move, copy, show/hide worksheets, adjust worksheet view, etc.)
- Manipulate rows and columns (insert, delete, copy, show/hide, group rows and columns, adjust row height and column width, etc.)
- Manipulate cells and cell ranges (set cell values, add hyperlinks to cells, name, copy and merge cells)
- Create formulas (use various functions and cell references in formulas, name formulas and use names in formulas, create shared and array formulas, etc.)
- Format cells (create, modify and apply styles, set cell font, colors, alignment, borders, number format, etc.)
- Import data from different sources
- Export the workbook to PDF
- Print the workbook
For more information, review the Examples section in the documentation.
The Universal Subscription or an additional Office File API Subscription is required to use this example in production code. Please refer to the DevExpress Subscription page for pricing information.
See also:
Spreadsheet Document API - Part 2
Spreadsheet Document API - Part 3