RowCount Property (SheetView)

Gets or sets the number of rows on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property RowCount As Integer

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

public int RowCount {get; set;}

Property Value

Integer number of rows in the data area of the sheet

Remarks

The maximum number of rows allowed in a sheet is 2,147,483,647 (or over 2 billion). This is the number of rows in the data area of the sheet. For the number of rows in the column header, refer to the ColumnHeader RowCount.

Example

This example illustrates the use of this member by returning the number of columns and rows in the spreadsheet.

int c, r;
c = fpSpread1.ActiveSheet.ColumnCount;
r = fpSpread1.ActiveSheet.RowCount;
listBox1.Items.Add(c.ToString() + " - " + r.ToString());

Visual Basic

Dim c, r As Integer
c = FpSpread1.ActiveSheet.ColumnCount
r = FpSpread1.ActiveSheet.RowCount
ListBox1.Items.Add(c.ToString() & " - " & r.ToString())

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetView Class
SheetView Members
ColumnCount Property

User-Task Documentation

Customizing the Number of Rows or Columns