Consolidation exercise error.

[ValentineTyan]

Hello, I have some problem with getting data from excel worksheet as collection.

On the stage "GetWorksheetAsCollection" I have error: Internal : Could not execute code stage because exception thrown by code stage: An object reference does not point to an instance of an object.

Thanks!

------------------------------
Valentine Tyan
------------------------------

[lookman]

Hi Valentine.

Please give us more context. What process or object is this happening in?

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[ValentineTyan]

Hi Jack,

It is happening in the MS Excel VBO, when I tried to collect data from excel worksheet.

Thanks!

------------------------------
Valentine Tyan
------------------------------

[Mohammed_OmerAl]

Hi Team,

Thank you for highlighting your query.

Please use action create instance of object Ms Excel Vbo and pass the output (handle) for get collection action. You will be able to get the data in a collection.

Let me know if you are facing any issues.

Thanks & Regards 

Omer