officefileapi-devexpress-dot-spreadsheet-dot-iworkbook-3ad5be8c.md
Returns the collection of worksheets in a workbook.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
WorksheetCollection Worksheets { get; }
ReadOnly Property Worksheets As WorksheetCollection
| Type | Description |
|---|---|
| WorksheetCollection |
The collection of Worksheet objects.
|
Use the WorksheetCollection object’s members to access, add, and remove worksheets.
Use the WorksheetCollection.Item property to access a worksheet in a workbook.
using DevExpress.Spreadsheet;
// ...
IWorkbook workbook = spreadsheetControl.Document;
// Access the worksheet collection.
WorksheetCollection worksheets = workbook.Worksheets;
// Access the first worksheet.
Worksheet worksheet1 = workbook.Worksheets[0];
Imports DevExpress.Spreadsheet
' ...
Dim workbook As IWorkbook = spreadsheetControl.Document
' Access the worksheet collection.
Dim worksheets As WorksheetCollection = workbook.Worksheets
' Access the first worksheet.
Dim worksheet1 As Worksheet = workbook.Worksheets(0)
A worksheet index is zero-based. It specifies the worksheet position within a collection.
using DevExpress.Spreadsheet;
// ...
IWorkbook workbook = spreadsheetControl.Document;
// Access the worksheet collection.
WorksheetCollection worksheets = workbook.Worksheets;
// Access the worksheet with the specified name.
Worksheet worksheet2 = workbook.Worksheets["MainSheet"];
Imports DevExpress.Spreadsheet
' ...
Dim workbook As IWorkbook = spreadsheetControl.Document
' Access the worksheet collection.
Dim worksheets As WorksheetCollection = workbook.Worksheets
' Access the worksheet with the specified name.
Dim worksheet2 As Worksheet = workbook.Worksheets("MainSheet")
A worksheet name is unique within the collection and is shown on a worksheet tab.
Use the WorksheetCollection.ActiveWorksheet property to specify the active worksheet in a workbook.
using DevExpress.Spreadsheet;
// ...
// Set "Sheet2" as the active worksheet.
workbook.Worksheets.ActiveWorksheet = workbook.Worksheets["Sheet2"];
Imports DevExpress.Spreadsheet
' ...
' Set "Sheet2" as the active worksheet.
workbook.Worksheets.ActiveWorksheet = workbook.Worksheets("Sheet2")
Use the WorksheetCollection.Add method to add a worksheet to the end of the worksheet collection.
using DevExpress.Spreadsheet;
// ...
// Add a worksheet with the default name.
// Default names are "Sheet1", "Sheet2", ..., "SheetN".
workbook.Worksheets.Add();
// Add new worksheets with the specified names.
workbook.Worksheets.Add().Name = "TestSheet1";
workbook.Worksheets.Add("TestSheet2");
Imports DevExpress.Spreadsheet
' ...
' Add a worksheet with the default name.
' Default names are "Sheet1", "Sheet2", ..., "SheetN".
workbook.Worksheets.Add()
' Add new worksheets with the specified names.
workbook.Worksheets.Add().Name = "TestSheet1"
workbook.Worksheets.Add("TestSheet2")
The WorksheetCollection.Insert method allows you to insert a worksheet at the specified position in the collection.
using DevExpress.Spreadsheet;
// ...
// Insert a worksheet at the second position in the workbook.
workbook.Worksheets.Insert(1, "TestSheet3");
// Insert a worksheet with the default name at the fourth position in the workbook.
workbook.Worksheets.Insert(3);
Imports DevExpress.Spreadsheet
' ...
' Insert a worksheet at the second position in the workbook.
workbook.Worksheets.Insert(1, "TestSheet3")
' Insert a worksheet with the default name at the fourth position in the workbook.
workbook.Worksheets.Insert(3)
Use the following methods to delete a worksheet:
WorksheetCollection.Remove - removes a specific worksheet from the collection.
WorksheetCollection.RemoveAt - removes the worksheet with the specified index from the collection.
Note
A workbook must contain at least one visible worksheet.
using DevExpress.Spreadsheet;
// ...
// Delete the first worksheet from the workbook.
workbook.Worksheets.RemoveAt(0);
// Delete the "Sheet2" worksheet from the workbook.
workbook.Worksheets.Remove(workbook.Worksheets["Sheet2"]);
Imports DevExpress.Spreadsheet
' ...
' Delete the first worksheet from the workbook.
workbook.Worksheets.RemoveAt(0)
' Delete the "Sheet2" worksheet from the workbook.
workbook.Worksheets.Remove(workbook.Worksheets("Sheet2"))
The following code snippets (auto-collected from DevExpress Examples) contain references to the Worksheets property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/CodeExamples/ChartSheetActions.cs#L11
#region #CreateChartSheet
Worksheet worksheet = workbook.Worksheets["chartTask1"];
winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/ChartSheetActions.cs#L11
#region #CreateChartSheet
Worksheet worksheet = workbook.Worksheets["chartTask1"];
#region #AddCalculatedField
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
#region #AddCalculatedField
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
#region #AddCalculatedField
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/DataTableActions.vb#L10
' #Region "#ShowDataTable"
Dim worksheet As Worksheet = workbook.Worksheets("chartTask5")
workbook.Worksheets.ActiveWorksheet = worksheet
winforms-spreadsheet-chart-api/VB/SpreadsheetChartAPISamples/CodeExamples/DataTableActions.vb#L8
#Region "#ShowDataTable"
Dim worksheet As Worksheet = workbook.Worksheets("chartTask5")
workbook.Worksheets.ActiveWorksheet = worksheet
' #Region "#AddCalculatedField"
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
' #Region "#AddCalculatedField"
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
#Region "#AddCalculatedField"
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
See Also