Syncfusion.XlsIO.Base
Example 


Cells Property (IRange)

Gets a IRange object that represents the cells in the Range. Read-only.
Syntax
'Declaration
 
ReadOnly Property Cells As IRange()
'Usage
 
Dim instance As IRange
Dim value() As IRange
 
value = instance.Cells
IRange[] Cells {get;}
Example
The following code illustrates how to access Cells property of the Range.
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Create(1);
            
IWorksheet sheet = workbook.Worksheets[0];
IRange[] cells = sheet["A1:E8"].Cells;
foreach (IRange Range in cells)
{
    // Do some manipulations
}
 
workbook.SaveAs("Cells.xlsx");
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also