topic Consolidation exercise error. in University Forum

Consolidation exercise error.

ValentineTyan — Wed, 07 Oct 2020 06:22:00 GMT

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

RE: Consolidation exercise error.

lookman — Wed, 07 Oct 2020 13:58:00 GMT

Hi Valentine.

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

jack

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

RE: Consolidation exercise error.

ValentineTyan — Thu, 08 Oct 2020 05:28:00 GMT

Hi Jack,

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

Thanks!

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

RE: Consolidation exercise error.

Mohammed_OmerAl — Thu, 08 Oct 2020 13:09:00 GMT

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