Excel does not show hidden sheet but if i unzip it then there are 2 worksheets

Question

I was therefore using the a.net library to write an application that reads excel files when I noticed that some excel files have two worksheets. I tried to utilize the unhide option in Excel after opening the file, but it was greyed out and seemed as if there were no hidden sheets. However, when I unzipped the excel file, I discovered that there were in fact two files in the xl > worksheets folder.

Why can't it be revealed? Do you have any other options for hiding a worksheet? Or was this worksheet created by Excel for a specific purpose and is now hidden?

Answer 1

I now know that an Excel worksheet can be in one of three states: "Visible," "Hidden," or "Very Hidden." The Visible and Hidden states of Excel options are switchable.

How and when does Excel alter the worksheet state to VeryHidden is the question. It appears that the Visual Basic Editor is the only tool that can convert it to VeryHidden. Additionally, you can manually edit the Excel file inside of workbook.xml in the xl folder after unzipping it.