Represents a collection of rows.

For a list of all members of this type, see IRangeRows Members.

[Visual Basic]
Public Interface IRangeRows
    Implements IRange, IEnumerable
[C#]
public interface IRangeRows : IRange, IEnumerable
[C++]
public __gc __interface IRangeRows : public IRange, IEnumerable
[JScript]
public interface IRangeRows extends IRange, IEnumerable

Remarks

Use the IRange.Rows, IRange.EntireRow properties to return the IRangeRows interface.

Example

This example sets the font style in the second row of range A1:F10 to bold.

[C#]
 IRangeRows rows = book.Worksheets[1].Range["A1:F10"].Rows;
 rows[2].Font.Bold = true;

[Visual Basic]
 Dim rows As IRangeRows = book.Worksheets(1).Range("A1:F10").Rows
 rows(2).Font.Bold = True

[C++]
 IRangeRows* rows = book->Worksheets->Item[1]->Range->Item[S"A1:F10"]->Rows;
 rows->Item[2]->Font->Bold = true;

This example copies the values from the second row of range A1:F10 to third.

[C#]
 IRangeRows rows = book.Worksheets[1].Range["A1:F10"].Rows;
 rows[3].Value = rows[2].Value;

[Visual Basic]
 Dim rows As IRangeRows = book.Worksheets(1).Range("A1:F10").Rows
 rows(3).Value = rows(2).Value

[C++]
 IRangeRows* rows = book->Worksheets->Item[1]->Range->Item[S"A1:F10"]->Rows;
 rows->Item[3]->Value = rows->Item[2]->Value;

Requirements

Namespace: NativeExcel

Assembly: NativeExcel (in NativeExcel.dll)

See Also

IRangeRows Members | NativeExcel Namespace | IRange.Rows Property | IRange.EntireRow Property

---