Spread Windows Forms 11.0 Product Documentation
AddColumns Method (DefaultSheetDataModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : AddColumns Method
Index of column at which to add a new column
Number of columns to add
Adds one or more columns to the data model at the specified position.
Syntax
'Declaration
 
Public Sub AddColumns( _
   ByVal column As Integer, _
   ByVal count As Integer _
) 
'Usage
 
Dim instance As DefaultSheetDataModel
Dim column As Integer
Dim count As Integer
 
instance.AddColumns(column, count)
public void AddColumns( 
   int column,
   int count
)

Parameters

column
Index of column at which to add a new column
count
Number of columns to add
Exceptions
ExceptionDescription
Specified column index is out of range; must be between zero and the number of columns
Specified number of columns is out of range; must be greater than zero
Example
This example adds five new columns and seven new rows to the data model.
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10);
dataModel.AddColumns(2, 5);
dataModel.AddRows(2, 7);
fpSpread1.ActiveSheet.Models.Data = dataModel;
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
dataModel.AddColumns(2, 5)
dataModel.AddRows(2, 7)
FpSpread1.ActiveSheet.Models.Data = dataModel
See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members