Collection of excel columns (ExcelColumn).
Namespace: GemBox.SpreadsheetAssembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 35.0.30.1025
Syntax
| C# |
|---|
public sealed class ExcelColumnCollection : ExcelRowColumnCollectionBase<ExcelColumn> |
| Visual Basic |
|---|
Public NotInheritable Class ExcelColumnCollection _ Inherits ExcelRowColumnCollectionBase(Of ExcelColumn) |
Remarks
Note that the cells are internally allocated in rows and not in columns. ExcelColumn objects are created only if they have non-standard width or style, or they are accessed directly. So, while ExcelRowCollection.Count shows number of rows occupied with data, ExcelColumnCollection.Count does not say which Column is the last one occupied with data!
If you want to read all data in a sheet, use ExcelRow.AllocatedCells property.
If you want to find last column occupied with data, use CalculateMaxUsedColumns method.
Inheritance Hierarchy
System..::..Object
GemBox.Spreadsheet..::..ExcelRowColumnCellCollectionBase
GemBox.Spreadsheet..::..ExcelRowColumnCollectionBase
GemBox.Spreadsheet..::..ExcelRowColumnCollectionBase<(Of <(<'ExcelColumn>)>)>
GemBox.Spreadsheet..::..ExcelColumnCollection
GemBox.Spreadsheet..::..ExcelRowColumnCellCollectionBase
GemBox.Spreadsheet..::..ExcelRowColumnCollectionBase
GemBox.Spreadsheet..::..ExcelRowColumnCollectionBase<(Of <(<'ExcelColumn>)>)>
GemBox.Spreadsheet..::..ExcelColumnCollection