Gets or sets the number of columns.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overridable Property ColumnCount As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As BaseSheetDataModel
Dim value As Integer
instance.ColumnCount = value
value = instance.ColumnCount |
| C# | |
|---|
public virtual int ColumnCount {get; set;} |
Property Value
Integer number of columns
Example
This example returns the number of non empty columns and rows.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.Model.BaseSheetDataModel bdm;
int c, r;
bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
bdm.ColumnCount = 5;
bdm.RowCount = 5;
bdm.SetValue(0, 0, "Not Empty");
c = bdm.NonEmptyColumnCount;
r = bdm.NonEmptyRowCount;
Response.Write("There are " + c + " non empty columns and " + r + " non empty rows.");
|
| Visual Basic | Copy Code |
|---|
Dim bdm As FarPoint.Web.Spread.Model.BaseSheetDataModel
Dim c, r As Integer
bdm = FpSpread1.ActiveSheetView.DataModel
bdm.ColumnCount = 5
bdm.RowCount = 5
bdm.SetValue(0, 0, "Not Empty")
c = bdm.NonEmptyColumnCount
r = bdm.NonEmptyRowCount
Response.Write("There are " & c & " non empty columns and " & r & " non empty rows.") |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
