Filtering excel file - error

Help Studio
1

Hello,

I have excel file with 106 columns and around 70000 rows.

First I want to remove existing filter and then filter based on variable. Column that I want to filter is placed in column C.

Currently I receive error:
“Filter: The range whose column you are trying to clear does not match the filtered range for this sheet.”

When I did such action for file with 10 columns and around 17000 rows everything went smoothly (I’ve tested for column A and C).
Is there any size limit for using UiPath or whats the reason of the issue?

image

2

there is no specific size limit for using UiPath with larger Excel files, this issue might be related to the specific Excel file structure or the way you are manipulating filters.

Some suggestion for Addressing the problem:

  1. clear exiting filter by using remove filter activity before applying new once
  2. double check the column reference in immediate panel and match with excel
  3. check if that column has consistent data or not

if still issue there you can share workflow also with files

Thanks !!

3

Referring to mention points:

Ad.1. “clear exiting filter by using remove filter activity” → Is it activity that I’ve shown already on printscreen or there is other activity that I should use?
Ad.2. “double check the column” → How to do this? Excel column and Column name are matching (“Plnt”). If I type “Plnt” and Filter_Variable in “immediate panel” I receive “Plnt” and “1005”.
Ad.3. “check if that column has consistent data” → It has “1005” that I want to filter and plenty other numbers that I’ve also used for testing and gave same error.

Additionallny - is there any way of highlighting cell that should be filtered?
I’ve tired Excel.Sheet(“Local_Currency”).Range(“C1”) but it doesn’t work in such way…

4

could you pls share excel ? if its does not have sensitive
information?

5

Data includes sensitive information.
During preparing dummy file base on those, filtering started to work after copy+paste data into different excel file :man_shrugging:

Before closing the topic:
Additionally - is there any way of highlighting cell that should be filtered?
In upcoming steps of my project, I’ll have reports that starts from for example cell D3.