ExcelRowColumnCellCollectionBase Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Base class for row, column and cell collections.

public abstract class ExcelRowColumnCellCollectionBase : IEnumerable
Public MustInherit Class ExcelRowColumnCellCollectionBase
    Implements IEnumerable
Inheritance:
System.Object
ExcelRowColumnCellCollectionBase
Derived
ExcelCellCollection
ExcelRowColumnCollectionBase
Implements
System.Collections.IEnumerable

Properties

Count

Gets the number of currently allocated elements (dynamically changes when worksheet is modified -- read remarks).

public abstract int Count { get; }
Public MustOverride ReadOnly Property Count As Integer
Property Value
System.Int32
Remarks

The cells are internally allocated in rows and not in columns. In other words, when you load CSV/XLS/XLSX or access some cells via worksheet.Cells property new rows and cells can be allocated but the column count will stay the same. To find last used column in the worksheet, use GemBox.Spreadsheet.ExcelWorksheet.GetUsedCellRange method.

Methods

GetEnumerator()

Returns an enumerator for the ExcelRowColumnCellCollectionBase.

public IEnumerator GetEnumerator()
Public Function GetEnumerator As IEnumerator
Returns
System.Collections.IEnumerator

An enumerator for the ExcelRowColumnCellCollectionBase.

Implements

System.Collections.IEnumerable

Examples