To install ReoGrid into .NET applications, see installation.
Usually used objects:
Workbook and Worksheet
The control itself is also workbook, a control (workbook) contains multiple worksheets.
Call control (workbook) APIs:
var grid = this.reoGridControl; grid.fun();
Call worksheet APIs:
var sheet = grid.CurrentWorksheet; sheet.fun();
Worksheet provides a lot of methods that could be used to manage cells data, styles, borders, outlines, ranges, formula calculation and etc. The below is an example that demos how to set cells data by call worksheet API.
Set cells data using worksheet index property:
// get current active worksheet instance var sheet = grid.CurrentWorksheet; // set cells data sheet["A1"] = "hello world"; sheet[2, 1] = 10;
sheet.SetCellData(new CellPosition(2, 1), "hello world");
Learn more about worksheet.
Access by doing actions
Action is undo-framework provided by ReoGrid core, many operations could be done by doing actions. Operations done via actions could be revoke by call Undo method of control. To do operations by using action:
1. Import this namespace:
DoAction method of grid control
grid.DoAction(grid.CurrentWorksheet, new xxxxAction(...));
To undo or redo actions:
Repeatedly do last action, apply it to another range:
grid.RepeatLastAction(new RangePosition(2, 3, 5, 5));
In Extension edition, the ECMAScript-like script execution functionality is supported. It provides the ability to run script language in ReoGrid. Learn more about Script Execution.
To use this feature, make sure the required reference libraries are added into project. see Install.
To run script:
Import the namespace:
Call workbook API to run script:
string script = "workbook.currentWorksheet.getCell("B1").data = 'hello world';"; grid.RunScript(script);
The user applications can extend the script functions and objects to provide own customize script features, see Customize Function.