How to set worksheet visibility to very hidden .NET?

It is easy to hide and unhide worksheets in .NET Excel library, 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.

Conclusion

A new version of Essential Studio for ASP.NET is available. Versions prior to the release of Essential Studio 2014, Volume 2 will now be referred to as a classic versions.The new ASP.NET suite is powered by Essential Studio for JavaScript providing client-side rendering of HTML 5-JavaScript controls, offering better performance, and better support for touch interactivity. The new version includes all the features of the old version, so migration is easy.

The Classic controls can be used in existing projects; however, if you are starting a new project, we recommend using the latest version of Essential Studio for ASP.NET. Although Syncfusion will continue to support all Classic Versions, we are happy to assist you in migrating to the newest edition.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls. If you have any queries or require clarifications, please let us know in the comments section below.

You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!