Syncfusion.XlsIO.Base
Example 


Columns Property (IRange)

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

Syncfusion.XlsIO.Base: 16.3460.0.29

See Also