Spread Windows Forms 11.0 Product Documentation
AddNewSheetView Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : AddNewSheetView Method
The sheet index is where the new SheetView is inserted or replaced. If sheetIndex is -1, the new SheetView is added to the end of SheetViewCollection.
The sheet name.
Row count of the new sheet. -1 for default count.
Column count of the new sheet. -1 for default count.
Indicates whether the new SheetView shares the named style of Spread
Indicates whether the new SheetView replaces the current sheet at the specified sheet index
Creates a new SheetView and inserts or replaces the sheet at the specified sheet index.
Syntax
'Declaration
 
Public Function AddNewSheetView( _
   Optional ByVal sheetIndex As Integer, _
   Optional ByVal sheetName As String, _
   Optional ByVal rowCount As Integer, _
   Optional ByVal columnCount As Integer, _
   Optional ByVal shareNamedStyle As Boolean, _
   Optional ByVal replace As Boolean _
) As SheetView
'Usage
 
Dim instance As FpSpread
Dim sheetIndex As Integer
Dim sheetName As String
Dim rowCount As Integer
Dim columnCount As Integer
Dim shareNamedStyle As Boolean
Dim replace As Boolean
Dim value As SheetView
 
value = instance.AddNewSheetView(sheetIndex, sheetName, rowCount, columnCount, shareNamedStyle, replace)
public SheetView AddNewSheetView( 
   int sheetIndex,
   string sheetName,
   int rowCount,
   int columnCount,
   bool shareNamedStyle,
   bool replace
)

Parameters

sheetIndex
The sheet index is where the new SheetView is inserted or replaced. If sheetIndex is -1, the new SheetView is added to the end of SheetViewCollection.
sheetName
The sheet name.
rowCount
Row count of the new sheet. -1 for default count.
columnCount
Column count of the new sheet. -1 for default count.
shareNamedStyle
Indicates whether the new SheetView shares the named style of Spread
replace
Indicates whether the new SheetView replaces the current sheet at the specified sheet index
Example
This example adds a new sheet view.
fpSpread1.AddNewSheetView(0, false, false);
FpSpread1.AddNewSheetView(0, False, False)
See Also

Reference

FpSpread Class
FpSpread Members