Syncfusion.XlsIO.Base
Example 


Rows Property (IRange)

Gets an array of IRange objects that represent the rows in the Range. Read only.
Syntax
'Declaration
 
ReadOnly Property Rows As IRange()
'Usage
 
Dim instance As IRange
Dim value() As IRange
 
value = instance.Rows
IRange[] Rows {get;}
Example
The following code illustrates how to access Columns 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[] rows = sheet["A1:E8"].Rows;
foreach (IRange row in rows)
{
    // Do some manipulations
}
            
workbook.SaveAs("Rows.xlsx");
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also