Spread Windows Forms 13.0 Product Documentation
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
Example


In This Topic
    AddColumns Method (DefaultSheetDataModel)
    In This Topic
    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