How to read Excel file with pre applied filters

Help Activities
1

Lets say…we received a email…with excel file attached to it

then automation is to save that excel, read it & do some task on it.

But here’s the issue

lets say…the sender has initially applied some filters on that excel to hide certain datas (which is required…as we dont need those data at this moment) & has sent that in e-mail to us

so how can i we read that excel file…with those filters pre applied??

so that , only selected data will only be visible, in uipath studio… so we can further work on those data

Please Guide me

2

Hi,

Could you please try with use filter option in read range activity to read the only filter data from the Excel so that we can store it in datatable and use it later. Usefilter is check box in the readrange activity by default is unchecked I guess. Please try.

Regards,
Kirankumar.

3

Hello @Jiban_Kumar_Das ,

You shall

  1. use the Excel Read range Activity within the Excel application scope and
  2. check the USE FILTER property in the read range activity.

This will return your expected Data table.

Hope this helps. Thanks.

1 Like
4

Hi

usually when using read range activity it just reads the data completely even though filter is applied with the excel file and that’s because the UseFilter property is disabled in read range

Enable it and try
It will read only the filtered data
image

Cheers @Jiban_Kumar_Das

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.