How to leave or delete hidden rows from excel

Learning Hub Academy Feedback
1

Hi All,

I have a input excel which contains the hidden rows also. While reading the excel data with the help of “read range” activity I dont want to read the hidden rows from the range in excel sheet.
Either I can delete the hidden rows first from that excel range and then read the data or after reading the data I delete the hidden rows.

How can I achieve this ,Please help.

2

@Karan28 You might be able to perform this if you know the condition to delete the hidden rows only. And can you maybe define what exactly are hidden rows in Excel ?