cancel
Showing results for 
Search instead for 
Did you mean: 

Key Not present in the Dictionery

AsitabhaDeb
Level 6
Hi ,

I have created custom BO under MS Excel VBO.
When I am trying to apply the BO in Process level below error is showing. I think my BO is correct otherwise it should show me other error mssg.
My requirement is I need to apply filter in big excel file. Filter collection option is not working as excel file consist 62000 row and 150 column,

Attachment for ref.
Please reply ASAP. Its urgent.

BR/Deb

------------------------------
Asitabha Deb
------------------------------
2 REPLIES 2

ShubhamJangam
Level 3
Hi,

Excel handle can be issue for it.
handle need to be created by same object.

------------------------------
Shubham Jangam
RPA Developer
Asia/Kolkata
------------------------------

ritansh.jatwani
Level 9
Hi Asitabha,

For applying filter, you can refer the below video:

https://www.youtube.com/watch?v=GiQgvUhbFM0

Also, this error generally comes due to memory leakage issue. In short, you can use "Attach" feature of MS Excel VBO before applying filter and it should work.

------------------------------
Ritansh Jatwani
Consultant
EY
Asia/Kolkata
------------------------------