My process works with excel files.
After opening the excel file, I need to clear any filters that may be applied.
But I can’t find a reliable way to check if filters are applied.
I tried using “Image Exists” activity to look for the following:
the down arrow box next to each column name when filters are on.
the filter icon from the “Sort & Filter” dropdown
the filter icon from Data tab.
These methods are unreliable and doesn’t always work.
Does anyone have any suggestions?