How to set worksheet visibility to very hidden?
It is easy to hide and unhide worksheets in Excel, but sometimes, you need to hide the worksheets and not to unhide by others using the normal Unhide feature. In this case, a higher level worksheet hiding - very hidden can help you make the worksheets very hidden and not be displayed to others easily. Essential XlsIO supports this feature in a very simple way setting worksheet’s visibility option.
To achieve this requirement, the workbook must contain more than one worksheet to be visible. The sample code to hide worksheet to very hidden state using XlsIO is given below.
ExcelEngine excelEngine = new ExcelEngine(); //Step 1 : Instantiate the excel application object. IApplication application = excelEngine.Excel; //The workbook is opened. IWorkbook workbook = application.Workbooks.Create(3); //The first worksheet object in the worksheets collection is accessed. IWorksheet worksheet = workbook.Worksheets; //To set the visibilty of the worksheet worksheet.Visibility = WorksheetVisibility.StrongHidden;
Dim excelEngine As ExcelEngine = New ExcelEngine() 'Step 1 : Instantiate the excel application object. Dim application As IApplication = excelEngine.Excel 'The workbook is opened. Dim workbook As IWorkbook = application.Workbooks.Create(3) 'The first worksheet object in the worksheets collection is accessed. Dim worksheet As IWorksheet = workbook.Worksheets(1) 'To set the visibilty of the worksheet worksheet.Visibility = WorksheetVisibility.StrongHidden