Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Applying filter conditions in excel through BluePrism

KummariSrikanth
Level 4

‎11-04-23 01:57 PM

Hi,
How to apply filter conditions in excel through blue prism & get that data into collection.


Regards,
Srikanth K



------------------------------
Kummari Srikanth
------------------------------
0 Likes
13 REPLIES 13

LakshmiNarayan3
Level 6
In response to KummariSrikanth

‎14-04-23 02:50 AM

Hi Srikanth

If you are looking for filter action , one action is already available in MS Excel VBO

25696.png
25697.png
There two more actions to apply and remove auto filter
You can leverage these actions

Regards



------------------------------
Lakshmi Narayana
------------------------------
0 Likes

KummariSrikanth
Level 4
In response to michaeloneil

‎14-04-23 02:00 PM

Hi
Yeah copy pasted this code from website. I am looking for multiple filtering criteria,but the above code is for single filter.

Regards
Srikanth K



------------------------------
Kummari Srikanth
------------------------------
0 Likes

KummariSrikanth
Level 4
In response to LakshmiNarayan3

‎17-04-23 06:17 AM

Hi Lakshmi Narayana,
     
I dont have the excel VBO for filters. I made a VBO with the above mentioned code but it is not working.

Regards,
Srikanth K  



------------------------------
Kummari Srikanth
------------------------------
0 Likes

LakshmiNarayan3
Level 6
In response to KummariSrikanth

‎17-04-23 06:35 AM

Download the latest version from DX portal , it is available in it

Regards



------------------------------
Lakshmi Narayana
------------------------------
0 Likes