RowCount Property (Worksheet)

Gets or sets the number of rows in the sheet.

Syntax

Visual Basic
C#

'Declaration
 
<DefaultValueAttribute()>
Public Property RowCount As Integer

'Usage
 
Dim instance As Worksheet
Dim value As Integer
 
instance.RowCount = value
 
value = instance.RowCount

[DefaultValue()]
public int RowCount {get; set;}

Property Value

The number of rows in the sheet.

Example

This example sets the RowCount property.

C#
VB.NET

gcSpreadSheet1.Sheets[0].RowCount = 10;
gcSpreadSheet1.Sheets[0].ColumnCount = 8;
gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenRowCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1;

GcSpreadSheet1.Sheets(0).RowCount = 10
GcSpreadSheet1.Sheets(0).ColumnCount = 8
GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenRowCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1

Reference

Worksheet Class
Worksheet Members