NonEmptyColumnCount Property (BaseSheetDataModel)

Gets the number of columns that contain data.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable ReadOnly Property NonEmptyColumnCount As Integer

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

public virtual int NonEmptyColumnCount {get;}

Property Value

Integer number of columns

Example

This example illustrates the use of this member by returning and displays the number of columns and rows that contain data.

FarPoint.Win.Spread.Model.BaseSheetDataModel dataModel;
int c, r;
dataModel = (FarPoint.Win.Spread.Model.BaseSheetDataModel)fpSpread1.ActiveSheet.Models.Data;
dataModel.ColumnCount = 5;
dataModel.RowCount = 5;
dataModel.SetValue(0, 0, "Not Empty");
c = dataModel.NonEmptyColumnCount;
r = dataModel.NonEmptyRowCount;
listBox1.Items.AddRange(new object[] {c.ToString(), r.ToString()});

Visual Basic

Dim dataModel As FarPoint.Win.Spread.Model.BaseSheetDataModel
Dim c, r As Integer
dataModel = FpSpread1.ActiveSheet.Models.Data
dataModel.ColumnCount = 5
dataModel.RowCount = 5
dataModel.SetValue(0, 0, "Not Empty")
c = dataModel.NonEmptyColumnCount
r = dataModel.NonEmptyRowCount
ListBox1.Items.AddRange(New Object() {c.ToString(), r.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

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members