using Infragistics.Documents.Excel;
...
//Accessing a single cell
WorksheetCell cellE2 = worksheet1.GetCell("E2");
//Accessing a range of cells
WorksheetRegion regionG = worksheet1.GetRegion("G1:G10");
You can access a WorksheetCell object or a WorksheetRegion object by calling the Worksheet object’s GetCell or GetRegion methods, respectively. Both methods accept a string parameter that references a cell. Getting a reference to a cell is useful when applying formats or working with formulas and cell contents. A typical usage of the GetRegion method is shown in Merging Cells article (for more information refer to the Related Topics section).
The following example code demonstrates how to reference cells and regions. The example code assumes you have a reference to a Worksheet object named worksheet1.
In C#:
using Infragistics.Documents.Excel;
...
//Accessing a single cell
WorksheetCell cellE2 = worksheet1.GetCell("E2");
//Accessing a range of cells
WorksheetRegion regionG = worksheet1.GetRegion("G1:G10");