How to: Access a Workbook

Apr 22, 2022

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.

C#
VB.NET

csharp

using DevExpress.Spreadsheet;
// ...

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

Imports DevExpress.Spreadsheet
' ...

' Access a workbook.
Dim workbook As IWorkbook = 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.