NativeExcel2 for .Net Developer's Reference

IRangeRows Interface

Represents a collection of rows.

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

[Visual Basic]
PublicInterfaceIRangeRows
ImplementsIRange, IEnumerable
[C#]
publicinterfaceIRangeRows:IRange, IEnumerable
[C++]
public__gc__interfaceIRangeRows: publicIRange, IEnumerable
[JScript]
publicinterfaceIRangeRowsextendsIRange, 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;
[VisualBasic]
 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;
[VisualBasic]
 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