Add a new
IExcelWorksheet instance to the underlying
IExcelWorkbook model.
Syntax
'Declaration
Sub AddSheet( _
ByVal As System.String, _
ByVal As System.Byte, _
ByVal 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 ,
System.byte ,
ExcelSheetType
)
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