AddColumns Method (DefaultSheetDataModel)

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

Syntax

Visual Basic
C#

'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

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

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;

Visual Basic

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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members