topic RE: Open Excel Error in Product Forum

Open Excel Error

JefersonRomão1 — Mon, 30 Dec 2019 22:35:00 GMT

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

RE: Open Excel Error

KrishnaA — Thu, 02 Jan 2020 05:06:00 GMT

Hello Jeferson,

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

Regards,

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

RE: Open Excel Error

JefersonRomão1 — Thu, 02 Jan 2020 14:56:00 GMT

Dear

Follows the steps where the errors occours.

Could you help please?

Sincerely

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

RE: Open Excel Error

diegobruno — Fri, 03 Jan 2020 20:56:00 GMT

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

RE: Open Excel Error

vivek.kumar.goel — Mon, 06 Jan 2020 06:12:00 GMT

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

RE: Open Excel Error

KrishnaA — Mon, 06 Jan 2020 07:14:00 GMT

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

RE: Open Excel Error

JefersonRomão1 — Mon, 06 Jan 2020 12:25:00 GMT

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