NonEmptyColumnCount Property (DefaultSheetDataModel)

In This Topic

Gets the number of columns in the model that contain data (bound or unbound).

Syntax

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

Remarks

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

Example

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

Visual Basic
C#

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

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));
}

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members