SpreadsheetControl.ActiveWorksheet Property

Gets the worksheet that is currently displayed in the SpreadsheetControl.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.1.dll

Declaration

C#

[Browsable(false)]
public Worksheet ActiveWorksheet { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property ActiveWorksheet As Worksheet

Property Value

Type	Description
Worksheet	A Worksheet object that specifies the active worksheet.

Remarks

A document loaded in the SpreadsheetControl is a workbook that consists of one or more worksheets (WorksheetCollection). A worksheet that is currently displayed in the SpreadhsheetControl and available to be modified by an end-user is called an active worksheet and returned by the ActiveWorksheet property.

You can also access and change an active worksheet in code using the WorksheetCollection.ActiveWorksheet property. An end-user can switch between worksheets using the SpreadsheetControl’s Sheet Tab Selector. Before and after an active worksheet is changed via the control’s UI, the SpreadsheetControl.ActiveSheetChanging and SpreadsheetControl.ActiveSheetChanged events are raised, respectively.

Example

To set an active worksheet within a workbook, assign the corresponding Worksheet object to the WorksheetCollection.ActiveWorksheet property.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-e4655

WorksheetActions.cs

// Set the second worksheet ("Sheet2") as the active worksheet.
workbook.Worksheets.ActiveWorksheet = workbook.Worksheets["Sheet2"];

WorksheetActions.vb

' Set the second worksheet ("Sheet2") as the active worksheet.
workbook.Worksheets.ActiveWorksheet = workbook.Worksheets("Sheet2")

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ActiveWorksheet 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.

C#

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L115

void EnableControls() {
    Worksheet sheet = spreadsheetControl1.ActiveWorksheet;
    if (sheet.Name == "Invoice") {

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/CS/SuppliersExample/Form1.cs#L41

    return;
Worksheet sheet = spreadsheetControl1.ActiveWorksheet;
string cellReference = cell.GetReferenceA1();

formula-engine-examples-of-use-t110344/CS/FormulaEngineTest/Form1.cs#L34

    contextCell = spreadsheetControl1.ActiveCell;
    contextSheet = spreadsheetControl1.ActiveWorksheet;
}

an-example-of-using-a-cell-range-as-a-data-source-t483776/CS/RangeDataSourceForSnap/Form1.cs#L30

RangeDataSourceOptions options = new RangeDataSourceOptions();
Worksheet sheet = spreadsheetControl1.ActiveWorksheet;
Range dataRange = sheet.Selection;

how-to-use-spreadsheet-control-to-create-a-data-entry-form/CS/DataEntryFormSample/MainForm.cs#L35

private void BindCustomEditors() {
    var sheet = spreadsheetControl1.ActiveWorksheet;
    // Assign custom editors to worksheet cells.

VB.NET

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L118

Private Sub EnableControls()
    Dim sheet As Worksheet = spreadsheetControl1.ActiveWorksheet
    If sheet.Name = "Invoice" Then

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/VB/SuppliersExample/Form1.vb#L42

End If
Dim sheet As Worksheet = spreadsheetControl1.ActiveWorksheet
Dim cellReference As String = cell.GetReferenceA1()

formula-engine-examples-of-use-t110344/VB/FormulaEngineTest/Form1.vb#L32

    contextCell = spreadsheetControl1.ActiveCell
    contextSheet = spreadsheetControl1.ActiveWorksheet
End Sub

an-example-of-using-a-cell-range-as-a-data-source-t483776/VB/RangeDataSourceForSnap/Form1.vb#L33

Dim options As New RangeDataSourceOptions()
Dim sheet As Worksheet = spreadsheetControl1.ActiveWorksheet
Dim dataRange As Range = sheet.Selection

how-to-use-spreadsheet-control-to-create-a-data-entry-form/VB/DataEntryFormSample/MainForm.vb#L30

Private Sub BindCustomEditors()
    Dim sheet = spreadsheetControl1.ActiveWorksheet