Articles in this section
Category / Section

How to set worksheet visibility to very hidden?

1 min read

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.

 

C#

           
           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[1];
 
            //To set the visibilty of the worksheet
            worksheet.Visibility = WorksheetVisibility.StrongHidden;

VB

            
            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
 

 

The sample illustrating this behavior can be downloaded here.

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied