Spread Windows Forms 8.0 Product Documentation
RowCount Property (SheetView)
Example 


Gets or sets the number of rows on this sheet.
Syntax
'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());
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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

SheetView Class
SheetView Members
ColumnCount Property

User-Task Documentation

Customizing the Number of Rows or Columns

 

 


Copyright © GrapeCity, inc. All rights reserved.