A newer version of this page is available. Switch to the current version.

How to: Access a Workbook

To programmatically modify a workbook loaded in the SpreadsheetControl, access the object implementing the IWorkbook interface via the SpreadsheetControl.Document property. This object is the starting point for using the SpreadsheetControl API.

using DevExpress.Spreadsheet;
// ...

// Access a workbook.
IWorkbook workbook = spreadsheetControl1.Document;

The IWorkbook interface provides a comprehensive set of properties and methods required to manipulate the workbook (for example, to load, save and print workbooks, manage worksheets, rows, columns and cells, use formulas in cells, format cells, etc.) For more information, see the Examples section.

See Also