NativeExcel2 for .Net Developer's Reference

IRangeRows.Item Property (Int32, Int32)

Returns IRangeRows interface that represents a subsequence or rows.

[C#] In C#, this property is the indexer for the IRangeRows class.

[Visual Basic]
DefaultPropertyReadOnlyItem(_
ByValFirstRowAsInteger,_
ByValLastRowAsInteger_
)AsIRangeRows
[C#]
IRangeRowsthis[
intFirstRow,
intLastRow
]{get;}
[C++]
__propertyIRangeRows*get_Item(
intFirstRow,
intLastRow
);
[JScript]
returnValue = IRangeRowsObject.Item( FirstRow,LastRow );
-or-
returnValue = IRangeRowsObject( FirstRow,LastRow );

[JScript] In JScript, you can use the default indexed properties defined by a type, but you cannot explicitly define your own. However, specifying the expando attribute on a class automatically provides a default indexed property whose type is Object and whose index type is String.

Parameters

FirstRow
The one-based index number of the first row
LastRow
The one-based index number of the last row

Property Value

Returns an IRangeRows interface.

Example

This example sets the height of rows one through five on sheet one.

[C#]
 book.Worksheets[1].Cells.Rows[1,5].RowHeight = 20; 
[VisualBasic]
 book.Worksheets[1].Cells.Rows(1,5).RowHeight = 20
[C++]
 book->Worksheets->Item[1]->Cells->Rows->Item[1,5]->RowHeight = 20;

See Also

IRangeRows Interface | NativeExcel Namespace | IRangeRows.Item Overload List