RowCollection.GetEnumerator

GetEnumerator()

Gets an enumerator that iterates rows through this collection

public IEnumerator GetEnumerator()

Return Value

enumerator

Examples

[C#]
Workbook workbook = new Workbook("template.xlsx");
Cells cells = workbook.Worksheets[0].Cells;

IEnumerator en = cells.Rows.GetEnumerator();
while (en.MoveNext())
{
    Row row = (Row)en.Current;
    Console.WriteLine(row.Index + ": " + row.Height);
}

See Also

GetEnumerator(bool, bool)

Gets an enumerator that iterates rows through this collection

public IEnumerator GetEnumerator(bool reversed, bool sync)
ParameterTypeDescription
reversedBooleanwhether enumerate rows in reversed order
syncBooleanwhether the returned enumerator should check the modification of row collection and keep synchronized with it.

Return Value

The row enumerator

Remarks

If the row collection will be modified(by operations that may cause new Row be instantiated or existing Row be removed) during the traversal with the enumerator, synchronized enumerator should be used instead of normal enumerator so that the traversal can continue from the position just after the one has been traversed by the last MoveNext(). However, together with the advantage that no element be skipped or traversed repeatedly, the disadvantage for synchronized enumerator is that the performance will be degraded a bit when comparing with normal enumerator.

See Also