Check if cell is hidden in Excel

(2) Share

Report

Posted on by JuanPuelloUSGBC

Hello,

I need to perform a check on an Excel workbook which is to validate is certain cell is hidden or not. I have tried some workarounds with built-in Excel actions but I could not achieve this.

Currently I am using UI actions as a workaround but I would want to avoid using them. So, is there another way to check if a cell is hidden?

Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

JuanPuello 5 on at

Like (0)

Report
Copy link

Link copied!

My current workaround is this one:
- Map the selector of the cell and use variables in the selector to check for any cell dynamically

- Use the if windows contains action to validate if the selector is found

- Before using the if windows contains action I had to make sure that the column/row that I am checking are visible on the screen, to do that I used the "Activate cell" action (If I don't do this and the sheet is scroll to the right for example and the cell is not visible on the screen, then the selector could not be found although the cell was not hidden)

Was this reply helpful? Yes No
Suggested answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
I recommend using VBScript to do this.

The following sample script will check if row 3 in sheet "Sheet1" is hidden in a document located at a path that is stored in a %ExcelDocument% variable:

Dim objExcel, objWorkbook, objSheet, isRowHidden ' Create an instance of Excel Set objExcel = CreateObject("Excel.Application") ' Open the specified workbook Set objWorkbook = objExcel.Workbooks.Open("%ExcelDocument%") ' Access the specified sheet Set objSheet = objWorkbook.Sheets("Sheet1") ' Check if row 3 is hidden isRowHidden = objSheet.Rows(3).Hidden ' Output the result WScript.Echo isRowHidden ' Close the workbook without saving objWorkbook.Close False ' Quit Excel objExcel.Quit ' Clean up Set objSheet = Nothing Set objWorkbook = Nothing Set objExcel = Nothing

You can also do the same with a column by changing "objSheet.Rows(3).Hidden" to "objSheet.Columns("C").Hidden" (which will check if column C is hidden).

Use the script in a Run VBScript action.

Was this reply helpful? Yes No