Gets the number of columns with data.
            
            
            
Syntax
| Visual Basic (Declaration) |   | 
|---|
ReadOnly Property NonEmptyColumnCount As Integer  | 
 
| Visual Basic (Usage) |  Copy Code | 
|---|
Dim instance As INonEmptyCells
Dim value As Integer
 
value = instance.NonEmptyColumnCount  | 
 
| C# |   | 
|---|
int NonEmptyColumnCount {get;} | 
 
            
            
            Property Value
Integer number of non-empty columns
 
            
			
			
            
            
            
Example
This example returns the number of non-empty columns and rows.
             
| C# |  Copy Code | 
|---|
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(); | 
 
| Visual Basic |  Copy Code | 
|---|
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()  | 
 
 
            
            
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