Spread WPF 17
GrapeCity.Excel Namespace / IExcelReader Interface / AddSheet Method
the name of the IExcelWorksheet
A value used to represent the sheet status, Worksheet in Excel has three status, visible, hidden and very hidden the corresponding value is 0,1,2. Since user can't set the Excelsheet status to very hidden by UI, it will be treated as hidden by default.
The sheet type.


In This Topic
    AddSheet Method
    In This Topic
    Add a new IExcelWorksheet instance to the underlying IExcelWorkbook model.
    Syntax
    'Declaration
     
    Sub AddSheet( _
       ByVal name As String, _
       ByVal hiddenState As Byte, _
       ByVal sheetType As ExcelSheetType _
    ) 
    'Usage
     
    Dim instance As IExcelReader
    Dim name As String
    Dim hiddenState As Byte
    Dim sheetType As ExcelSheetType
     
    instance.AddSheet(name, hiddenState, sheetType)
    void AddSheet( 
       string name,
       byte hiddenState,
       ExcelSheetType sheetType
    )

    Parameters

    name
    the name of the IExcelWorksheet
    hiddenState
    A value used to represent the sheet status, Worksheet in Excel has three status, visible, hidden and very hidden the corresponding value is 0,1,2. Since user can't set the Excelsheet status to very hidden by UI, it will be treated as hidden by default.
    sheetType
    The sheet type.
    See Also