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
• 38,010 points
387 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
• 63,700 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, 2023 in Others by narikkadan
• 63,700 points
337 views
0 votes
1 answer

How to show a row in excel if there is a X

FILTER Function: "filters" a range of data ...READ MORE

answered Feb 2, 2023 in Others by narikkadan
• 63,700 points
221 views
0 votes
1 answer

IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE

answered Mar 20, 2023 in Others by narikkadan
• 63,700 points
401 views
0 votes
1 answer

Excel - How do I round a date type to the next hour if it is more than one minute

Add almost 30 minutes and it'll get ...READ MORE

answered Mar 27, 2023 in Others by narikkadan
• 63,700 points
251 views
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
• 63,700 points
1,306 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
• 63,700 points
1,632 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
974 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,090 points
895 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
• 63,700 points
334 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, 2023 in Others by narikkadan
• 63,700 points
469 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