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 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.
| 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8