Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub Insert( _ ByVal index As Integer, _ ByVal sheetView As SheetView _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetViewCollection Dim index As Integer Dim sheetView As SheetView instance.Insert(index, sheetView) | |
Parameters
- index
- Zero-based index at which to insert the sheet
- sheetView
- Sheet (SheetView object) to insert into the collection
Exceptions
| Exception | Description |
|---|---|
| System.ArgumentNullException | Sheet is not specified (that is, specified sheet is null) |
Example
This example inserts a sheet into the collection at the specified index.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.SheetView mySheet = new FarPoint.Win.Spread.SheetView();
fpSpread1.Sheets.Count = 2;
mySheet.ColumnCount = 4;
mySheet.RowCount = 4;
fpSpread1.Sheets.Insert(1, mySheet);
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always; | |
| Visual Basic | Copy Code |
|---|---|
Dim mySheet As New FarPoint.Win.Spread.SheetView() FpSpread1.Sheets.Count = 2 mySheet.ColumnCount = 4 mySheet.RowCount = 4 FpSpread1.Sheets.Insert(1, mySheet) FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always | |
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