Hide and Display a Worksheet
Hide a Worksheet
Code Sample
// Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook ();
//Add a new worksheet
workbook.Worksheets.Add("newsheet");
//Get the first worksheet
XlsWorksheet worksheet = workbook.Worksheets[0];
//Hide the sheet
worksheet.Visibility = XlsVisibility.Hidden;
//Save the Excel file
workbook.Save("C:\book1.xls")
'Instantiating a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
'Add a new worksheet
workbook.Worksheets.Add("newsheet")
'Get the first worksheet
Dim worksheet As XlsWorksheet = workbook.Worksheets(0)
'Hide the sheet
worksheet.Visibility = XlsVisibility.Hidden;
'Save the Excel file
workbook.Save("C:\book1.xls")
Display a Worksheet
Code Sample
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
//Add a new worksheet
workbook.Worksheets.Add("newsheet");
//Get the first worksheet
XlsWorksheet worksheet = workbook.Worksheets[0];
//Show the sheet
worksheet.Visibility = XlsVisibility.Visible;
//Save the Excel file
workbook.Save("C:\book1.xls")
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook()
'Add a new worksheet
workbook.Worksheets.Add("newsheet")
'Get the first worksheet
Dim worksheet As XlsWorksheet= workbook.Worksheets(0)
'Show the sheet
worksheet.Visibility = XlsVisibility.Visible;
'Save the Excel file
workbook.Save("C:\book1.xls")