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

0 votes
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?
Nov 12 in Others by Kithuzzz
• 20,660 points
32 views

1 answer to this question.

0 votes
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.
answered Nov 12 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
58 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
452 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
397 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,373 views
0 votes
1 answer

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
39 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP