Can't read excel to collection offset because "the given key was not present in the dictionary" error in code stage.

[kashishyuvrajjain]

I'm trying to use the Excel VBO Get Excel as Collection Offset but there seems to be an error when the object checks the handle and also at a later stage where the code stage is supposed to run.
View attachment 1571041112801.png
View attachment 1571041158081.png

 

[Manikanta]

I'm trying to use the Excel VBO Get Excel as Collection Offset but there seems to be an error when the object checks the handle and also at a later stage where the code stage is supposed to run.
View attachment 4674
View attachment 4675

Hi @kashishyuvrajjain
R u trying to edit the code stage of MS Excel VBO?
If u done changes,that's y u r getting that error.

 

[shikhar.mishra]

Hi @kashishyuvrajjain ,

There might be some error in the passing the sheet name. Bcz I just checked as per the screenshot attached you are using GET WORKSHEET AS Collection action of MS Excel VBO. so while passing please ensure sheet name is fine and also release all instances before and after if any excel instances are opened.

Happy to Help

Shikhar