topic RE: Key Not present in the Dictionery in Product Forum

Key Not present in the Dictionery

AsitabhaDeb — Tue, 27 Oct 2020 05:01:00 GMT

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
------------------------------

RE: Key Not present in the Dictionery

ShubhamJangam — Tue, 27 Oct 2020 13:34:00 GMT

Hi,

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

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

RE: Key Not present in the Dictionery

ritansh.jatwani — Tue, 27 Oct 2020 17:12:00 GMT

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
------------------------------