Spread Windows Forms 13.0 Product Documentation
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
Example


In This Topic
    AddNewSheetView Method
    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 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