From version 0.8.8.0, multiple worksheet was available. Default control appearance:
To access worksheet, use
var sheet1 = reoGridControl.CurrentWorksheet;
Component object structure
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 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.
// 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.
var sheet2 = grid.CopyWorksheet(0, 1); // sheet name could also be set here
Some events are available to monitor the changes of worksheet management.
To reset a workbook to initial status, use Reset method:
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