GrapeCity.Xaml.Excel
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 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.
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

IExcelReader Interface
IExcelReader Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options