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


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
System.ArgumentOutOfRangeException Specified column index is out of range; must be between zero and the number of columns
System.ArgumentOutOfRangeException 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
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.