We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to set worksheet visibility to very hidden?

Platform: ASP.NET Web Forms |
Control: XlsIO |
Published Date: May 14, 2015 |
Last Revised Date: May 14, 2015

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#

VB

 

The sample illustrating this behavior can be downloaded here.

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon