Read column A from Excel and get rows?

I have data about 5000+ rows.

I want to read row excel unhide only (Column A) ?
File Excel as attached : data hide.xlsx (8.5 KB)


Step 1 : Filter Column Recheck = “” and STATUS_CD = #N/A

Step2 : Read Column A by row and get row from excel.

Please guide me about it.


Can you try to UseFilter option of ReadRange Activity? (8.6 KB)


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.