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, 2022 in Others by Kithuzzz
• 27,740 points
61 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, 2022 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

answered Jan 21 in Others by narikkadan
• 51,240 points
41 views
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, 2022 in Others by narikkadan
• 51,240 points
153 views
0 votes
1 answer

xlsx package:Write excel file to a custom path

The issue is that when you send ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
• 51,240 points
164 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,740 points
523 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
470 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, 2022 in Others by narikkadan
• 51,240 points
75 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9 in Others by narikkadan
• 51,240 points
32 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