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!