topic RE: Open workbook object issue in Product Forum

Open workbook object issue

NarendranathanS — Fri, 20 Dec 2019 15:01:00 GMT

Dear all,

Excel "Open workbook" object fails to work at code stage.

Here is error prompted when the action is executed.

Can anybody help resolving this issue?

------------------------------
Narendranathan Shanmuganathan
------------------------------

RE: Open workbook object issue

david.l.morris — Fri, 20 Dec 2019 17:08:00 GMT

The embedded image for the error isn't loading for me. What does it say?

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: Open workbook object issue

NarendranathanS — Sat, 21 Dec 2019 21:15:00 GMT

Error message in the embedded image,

Internal : Could not execute code stage because exception thrown by code stage. Exception has been thrown by the target of an invocation.

Kr,
Naren

------------------------------
Narendranathan Shanmuganathan
------------------------------

RE: Open workbook object issue

NarendranathanS — Mon, 23 Dec 2019 13:56:00 GMT

Hi Dave,

Does this message help you identify the cause?

Internal : Could not execute code stage because exception thrown by code stage. Exception has been thrown by the target of an invocation.

May you require more detail please let me know.

Kr,
Naren

------------------------------
Kr,
Naren
------------------------------

RE: Open workbook object issue

sumire — Tue, 24 Dec 2019 06:17:00 GMT

I can show same message in my environment
when I specify word file instead of excel file to open

check your file, really excel file or not

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: Open workbook object issue

NarendranathanS — Tue, 24 Dec 2019 08:08:00 GMT

Hi Mitsuko,

Certainly the action "Open workbook" tries to open an excel file. Also instance was created before this action and tested successfully by passing the handle value to show action. Same handle value was provided to open workbook action as well.

------------------------------
Kr,
Naren
------------------------------

RE: Open workbook object issue

sumire — Thu, 26 Dec 2019 00:33:00 GMT

is your xlsx file really excel file, I feel like you should open it
I mean if it is broken, or incorrect extension, etc

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: Open workbook object issue

NarendranathanS — Fri, 27 Dec 2019 11:32:00 GMT

File sample.xlsx opens without a problem in excel application when I opened by double clicking the file. Apparently it's not broken and file extension is not incorrect in the blueprism process.

------------------------------
Kr,
Naren
------------------------------