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) | |
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 |
Example
This example adds five new columns and seven new rows to the data model.
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2