Partager via


Worksheet.Rows Property

Gets a Range object that represents one or more rows on the worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
ReadOnly Property Rows As Range
Range Rows { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range
A Range object that represents one or more rows on the worksheet.

Remarks

When used without parameters, this property returns a Range object that contains all the rows on the worksheet.

This property can be used with the following optional parameters to get specific rows on the worksheet. If you use this property with parameters, the return value is an object that must be cast to a Range.

Parameter

Description

RowIndex

The index of one or more rows to get.

To get a single row, pass an integer that specifies the index of the row you want to get. The row indexes begin at 1.

To get multiple contiguous rows, pass a string with the format "first row:last row". For example, to get rows 1 through 5, pass "1:5".

ColumnIndex

Do not use this parameter. This property will throw a COMException if you try to pass a value to this parameter.

.NET Framework Security

See Also

Reference

Worksheet Interface

Microsoft.Office.Tools.Excel Namespace