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?