In This Topic
Creates a new SheetView and inserts or replaces the sheet at the specified sheet index.
Syntax
'Declaration
Public Function AddNewSheetView( _
Optional ByVal As Integer, _
Optional ByVal As String, _
Optional ByVal As Integer, _
Optional ByVal columnCount As Integer, _
Optional ByVal As Boolean, _
Optional ByVal 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)
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
See Also