ExcelRowCollection Class

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

Collection of excel rows (ExcelRow).

public sealed class ExcelRowCollection : ExcelRowColumnCollectionBase<ExcelRow>, IEnumerable<ExcelRow>, IEnumerable
Public NotInheritable Class ExcelRowCollection
    Inherits ExcelRowColumnCollectionBase(Of ExcelRow)
    Implements IEnumerable(Of ExcelRow), IEnumerable
Inheritance:
System.Object
ExcelRowCollection
Implements
System.Collections.Generic.IEnumerable<ExcelRow>
System.Collections.IEnumerable

Properties

Item[Int32]

Gets the row with the specified index.

public override ExcelRow this[int index] { get; }
Public Overrides ReadOnly Property Item(index As Integer) As ExcelRow
Parameters
index
System.Int32

The zero-based index of the row.

Property Value
ExcelRow
Overrides
GemBox.Spreadsheet.ExcelRowColumnCollectionBase<GemBox.Spreadsheet.ExcelRow>.Item[System.Int32]

Methods

InsertCopy(Int32, ExcelRow)

Inserts copied row at the specified index.

public void InsertCopy(int rowIndex, ExcelRow sourceRow)
Public Sub InsertCopy(rowIndex As Integer, sourceRow As ExcelRow)
Parameters
rowIndex
System.Int32

The zero-based index of the row.

sourceRow
ExcelRow

Source row to copy.

InsertCopy(Int32, Int32, ExcelRow)

Inserts specified number of copied rows at the specified index.

public void InsertCopy(int rowIndex, int rowCount, ExcelRow sourceRow)
Public Sub InsertCopy(rowIndex As Integer, rowCount As Integer, sourceRow As ExcelRow)
Parameters
rowIndex
System.Int32

The zero-based index of the row.

rowCount
System.Int32

Number of rows to insert.

sourceRow
ExcelRow

Source row to copy.

InsertEmpty(Int32)

Inserts empty row at the specified index.

public void InsertEmpty(int rowIndex)
Public Sub InsertEmpty(rowIndex As Integer)
Parameters
rowIndex
System.Int32

The zero-based index of the row.

InsertEmpty(Int32, Int32)

Inserts specified number of empty rows at the specified index.

public void InsertEmpty(int rowIndex, int rowCount)
Public Sub InsertEmpty(rowIndex As Integer, rowCount As Integer)
Parameters
rowIndex
System.Int32

The zero-based index of the row.

rowCount
System.Int32

Number of rows to insert.

Remove(Int32)

Removes the row with the specified index.

public void Remove(int rowIndex)
Public Sub Remove(rowIndex As Integer)
Parameters
rowIndex
System.Int32

The zero-based index of the row.

Remove(Int32, Int32)

Removes specified number of rows starting at the specified index.

public void Remove(int rowIndex, int rowCount)
Public Sub Remove(rowIndex As Integer, rowCount As Integer)
Parameters
rowIndex
System.Int32

The zero-based index of the row.

rowCount
System.Int32

Number of rows to remove.

RowIndexToName(Int32)

Converts row index (0, 1, ...) to row name ("1", "2", ...).

public static string RowIndexToName(int rowIndex)
Public Shared Function RowIndexToName(rowIndex As Integer) As String
Parameters
rowIndex
System.Int32

Row index.

Returns
System.String

Row name for the specified index.

RowNameToIndex(String)

Converts row name ("1", "2", ...) to row index (0, 1, ...).

public static int RowNameToIndex(string name)
Public Shared Function RowNameToIndex(name As String) As Integer
Parameters
name
System.String

Row name.

Returns
System.Int32

Row index for the specified name.

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable

Examples

See Also