Spread for ASP.NET 11 Product Documentation
RowCount Property (BaseSheetDataModel)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > BaseSheetDataModel Class : RowCount Property
Gets or sets the number of rows.
Syntax
'Declaration
 
Public Overridable Property RowCount As Integer
'Usage
 
Dim instance As BaseSheetDataModel
Dim value As Integer
 
instance.RowCount = value
 
value = instance.RowCount
public virtual int RowCount {get; set;}

Property Value

Integer number of rows
Example
This example returns the number of non empty columns and rows.
FarPoint.Web.Spread.Model.BaseSheetDataModel bdm;
int c, r;
bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
bdm.ColumnCount = 5;
bdm.RowCount = 5;
bdm.SetValue(0, 0, "Not Empty");
c = bdm.NonEmptyColumnCount;
r = bdm.NonEmptyRowCount;
Response.Write("There are " + c + " non empty columns and " + r + " non empty rows.");
Dim bdm As FarPoint.Web.Spread.Model.BaseSheetDataModel
Dim c, r As Integer
bdm = FpSpread1.ActiveSheetView.DataModel
bdm.ColumnCount = 5
bdm.RowCount = 5
bdm.SetValue(0, 0, "Not Empty")
c = bdm.NonEmptyColumnCount
r = bdm.NonEmptyRowCount
Response.Write("There are " & c & " non empty columns and " & r & " non empty rows.")
See Also

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members
ColumnCount Property