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
Hi Angela Marie Miranda that is the current expected behavior, as ranges do not change although you filter some rows of columns.
A current workaround could be using the Copy/Paste option (License Required module). That option includes a "only visible data" checkbox so you can copy the filtered data and paste them in a different location to check them.