Spread Windows Forms 11.0 Product Documentation
ColumnCount Property (BaseSheetDataModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > BaseSheetDataModel Class : ColumnCount Property
Gets or sets the number of columns.
Syntax
'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
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()});
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()})
See Also

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members