ColumnCount Property (BaseSheetDataModel)

Visual Basic
C#

'Declaration
 
Public Overridable Property ColumnCount As Integer

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

public virtual int ColumnCount {get; set;}

Property Value

Integer number of columns in the data model

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

C#

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

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members