FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > INonEmptyCells Interface : NonEmptyColumnCount Property |
'Declaration ReadOnly Property NonEmptyColumnCount As Integer
'Usage Dim instance As INonEmptyCells Dim value As Integer value = instance.NonEmptyColumnCount
int NonEmptyColumnCount {get;}
FarPoint.Win.Spread.Model.INonEmptyCells nec; Random r = new Random(); int countc, countr; int i, j; for (i = 0; i<=50; i++) { for (j = 0; j<=3; j++) fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString()); } nec = (FarPoint.Win.Spread.Model.INonEmptyCells)fpSpread1.ActiveSheet.Models.Data; countc = nec.NonEmptyColumnCount; countr = nec.NonEmptyRowCount; label1.Text = "The number of the first non-empty column is " + countc.ToString() + " and the number of the first non-empty row is " + countr.ToString();
Dim nec As FarPoint.Win.Spread.Model.INonEmptyCells Dim r As New Random() Dim i, j As Integer Dim countc, countr As Integer For i = 0 To 50 For j = 0 To 3 FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString()) Next j Next i nec = FpSpread1.ActiveSheet.Models.Data countc = nec.NonEmptyColumnCount countr = nec.NonEmptyRowCount Label1.Text = "The number of the first non-empty column is " & countc.ToString() & " and the number of the first non-empty row is " & countr.ToString()
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
INonEmptyCells Interface
INonEmptyCells Members
NonEmptyItemFlag Enumeration