Appian RPA : How to get the visible rows after filtering of an Excel file?

Note: Using actions under Excel: Licensed Required

I am having an issue where I could not get the visible rows of the Excel file after filtering it. 

Steps I am currently doing in my robotic task: 

1. Open Workbook,

2. Get the last range of the current worksheet. 

2. Filter the first column by the variable: dateFilter (only filtered rows are now visible on the file).

3. Get the range, (I am getting ALL of the rows, even the invisible ones)

4. Close Workbook.

Thank you!

  Discussion posts and replies are publicly visible