Spread WPF Documentation
AddSheet Method


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.
Add a new IExcelWorksheet instance to the underlying IExcelWorkbook model.
Syntax
'Declaration
 
Sub AddSheet( _
   ByVal name As System.String, _
   ByVal hiddenState As System.Byte, _
   ByVal sheetType As ExcelSheetType _
) 
'Usage
 
Dim instance As IExcelReader
Dim name As System.String
Dim hiddenState As System.Byte
Dim sheetType As ExcelSheetType
 
instance.AddSheet(name, hiddenState, sheetType)
void AddSheet( 
   System.string name,
   System.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

Reference

IExcelReader Interface
IExcelReader Members