Adds one or more columns to the data model at the specified position.

Syntax

Visual Basic (Declaration)
Public Sub AddColumns( _ ByVal column As Integer, _ ByVal count As Integer _ )

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim column As Integer Dim count As Integer instance.AddColumns(column, count)

C#
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

Exception	Description
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

Remarks

If you want to add a single column, use the AddColumn method.

Example

This example shows the use of this method by adding a new column to the model in the click event of a button and placing it in front of the fourth column.

C#	Copy Code
Private void Button1_Click(object sender, System.EventArgs e) { FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; dm.AddColumns(2, 2); }

Copy Code

 Private void Button1_Click(object sender, System.EventArgs e)
{
  FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
  dm.AddColumns(2, 2);        
}

Visual Basic	Copy Code
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel = CType(FpSpread1.ActiveSheetView.DataModel, FarPoint.Web.Spread.Model.DefaultSheetDataModel) dm.AddColumns(2, 2) End Sub

Visual Basic

Copy Code

Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
  Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel = CType(FpSpread1.ActiveSheetView.DataModel, FarPoint.Web.Spread.Model.DefaultSheetDataModel)
  dm.AddColumns(2, 2)
End Sub

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