FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > BaseSheetDataModel Class : NonEmptyRowCount Property |
'Declaration Public Overridable ReadOnly Property NonEmptyRowCount As Integer
'Usage Dim instance As BaseSheetDataModel Dim value As Integer value = instance.NonEmptyRowCount
public virtual int NonEmptyRowCount {get;}
This property returns a value that is one more than the index of the last row in the model that contains data.
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.")
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6