Get hidden rows and sheets in an Excel

[rahullakshmanan]

Hi Team,

I need to know the following from a given Excel table:

• The hidden sheets in an excel workbook
• The hidden rows in an active or set excel sheet in a workbook. The hidden rows are always between rows 42 to rows 47.

Let me know how can i solve this in power automate dekstop.

[yasunm02 · Accepted solution]

PAD doesnt have actions to perform that.

An alternative is to make PAD run a VBA in Excel (an example of a code is here: Finding hidden sheets (and hidden cells) in excel with VBA - Stack Overflow) and capture the result