Excel Automation of hidden rows

Help Studio
1

Hi,

below is the excel table where I need to get the data
image

I want the Cities names under the Merged cell called “Name of city”. There are some hidden rows as well. How to achieve this

Thanks in advance

2

@raju_alakuntla,

Read Range activity should read visible as well as hidden values as well. Try this and let me know if any error.

Thanks,
Ashok :slight_smile:

3

I need only visible rows only and I am not reading entire sheet. I am using read cell activity But the cell position will be dynamic and text(City name) also dynamic.

4

@raju_alakuntla,

Check this Visible Rows Only checkbox.

image
e

5

Actually I don’t want to read entire sheet but need to read only the visible rows under the “Name of City”. Is there any activity to get only those?