Spread WPF Documentation
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.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

IExcelReader Interface
IExcelReader Members

 

 


Copyright © GrapeCity, inc. All rights reserved.