NonEmptyColumnCount Property (DefaultSheetDataModel)

Visual Basic
C#

'Declaration
 
Public Overrides ReadOnly Property NonEmptyColumnCount As Integer

'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Integer
 
value = instance.NonEmptyColumnCount

public override int NonEmptyColumnCount {get;}

Property Value

Integer number that is one more than the index of the last column in the model that contains data

This property returns a value that is one more than the index of the last column in the model that contains data.

This example assigns values to the Spread data model and returns the number of non-empty columns and rows.

Visual Basic

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)HandlesMyBase.Load
If(IsPostBack)Then
Return
EndIf

FpSpread1.ActiveSheetView.DataModel.SetValue(0,0,"First")
FpSpread1.ActiveSheetView.DataModel.SetValue(0,1,"Second")
FpSpread1.ActiveSheetView.DataModel.SetValue(0,2,"Third")
FpSpread1.ActiveSheetView.DataModel.SetValue(2,0,"Un")
FpSpread1.ActiveSheetView.DataModel.SetValue(2,1,"Deux")
FpSpread1.ActiveSheetView.DataModel.SetValue(2,2,"Trois")

DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetDataModel=FpSpread1.ActiveSheetView.DataModel
ListBox1.Items.Add(Convert.ToString(model.NonEmptyColumnCount))
ListBox1.Items.Add(Convert.ToString(model.NonEmptyRowCount))
End Sub

C#

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FpSpread1.ActiveSheetView.DataModel.SetValue(0,0,"First");
FpSpread1.ActiveSheetView.DataModel.SetValue(0,1,"Second");
FpSpread1.ActiveSheetView.DataModel.SetValue(0,2,"Third");
FpSpread1.ActiveSheetView.DataModel.SetValue(2,0,"Un");
FpSpread1.ActiveSheetView.DataModel.SetValue(2,1,"Deux");
FpSpread1.ActiveSheetView.DataModel.SetValue(2,2,"Trois");

FarPoint.Web.Spread.Model.DefaultSheetDataModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
ListBox1.Items.Add(Convert.ToString(model.NonEmptyColumnCount));
ListBox1.Items.Add(Convert.ToString(model.NonEmptyRowCount));
}

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members