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 new column
count: Number of columns to add

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified index of column 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family