Open Excel Error

[JefersonRomão1]

Dear Community !!

I' m facing a big issue, I did a lot os test but doens't work well.

Please someone can help me?

Follows below the error message:

Help please!!

Thank you!!

------------------------------
Jeferson Romão
------------------------------

[KrishnaA]

Hello Jeferson, 

Could you share more details about the actual step you were trying with Excel Object?

Regards,

------------------------------
Krishna A
Blue Prism
------------------------------

[JefersonRomão1]

Dear 

Follows the steps where the errors occours.

Could you help please?

Sincerely

------------------------------
Jeferson Romão
------------------------------

[diegobruno]

Dear Jeferson Romão,

      It seams that the handle is empty, you need to use "Create Instance" action first.

      Create Instance>Show>Open Workbook.

Regards,

------------------------------
Diego Bruno Saraiva Alves
Engineer
Dirwa
America/Fortaleza
------------------------------

[VivekGoel]

Please use "Create Instance" take the output as handle and pass that handle into the open workbook action.

However, on a separate note, you can directly use "read csv" action for csv files 🙂

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

[KrishnaA]

Hello Jeferson,

If the requirement is to read CSV into the collection, suggest exploring VBO - "BPA Object - Utility - File Management.xml".
Import the out of the box VBO into your Blue Prism instance and make use of "Get CSV Text As Collection" action to read the CSV file.

Otherwise, you can continue to use Excel VBO.  However, as others suggest please create the excel instance using appropriate action and use the handle to read the contents.

Hope this helps.

Best regards,

------------------------------
Krishna A
Blue Prism
------------------------------

[JefersonRomão1]

Dear Community!

I fixed my issue I reinstalled the office, and the issue was solved.

Thank you all for the tips.


Best regards

------------------------------
Jeferson Romão
------------------------------