Multiple worksheet overview

From version 0.8.8.0, multiple worksheet was available. Default control appearance:

217

To access worksheet, use CurrentWorksheet instance:

var sheet1 = reoGridControl.CurrentWorksheet;

Component object structure

231

Worksheet Management

Current worksheet instance

The screen control workbook keeps an instance of activated worksheet, which is displayed for user as current worksheet. To get or set current worksheet, use CurrentWorksheet property of workbook.

var sheet = grid.CurrentWorksheet;
...

Create worksheet

// create worksheet
var sheet = grid.CreateWorksheet();

// create worksheet with a specified name
var sheet = grid.CreateWorksheet('mysheet');

If no name was specified, or the specified name is empty or null, ReoGrid will find an available name such as ‘Sheet1’, ‘Sheet2’ … automatically.

Add/Insert worksheet

// call method
grid.AddWorksheet(sheet);
grid.InsertWorksheet(1, sheet);

// use collection of worksheet
grid.Worksheets.Add(sheet);
grid.Worksheets.Insert(1, sheet);

Notice that it is not allowed to have same name from different two worksheets in a workbook.

Copy worksheet

var sheet2 = grid.CopyWorksheet(0, 1); // sheet name could also be set here

Move worksheet

grid.MoveWorksheet(0, 3);

Events

Some events are available to monitor the changes of worksheet management.

  • WorksheetCreated
  • WorksheetInserted
  • WorksheetRemoved
  • BeforeWorksheetNameChange
  • WorksheetNameChanged

Reset workbook

To reset a workbook to initial status, use Reset method:

workbook.Reset();

Built-in sheet tab control

Both windows form and WPF edition provide the built-in sheet tab control:

For details see Working with built-in sheet tab control.


Return to Document

Next: Built-in Sheet Tab Control