topic But use [File Path] & … in Product Forum

Open workbook has error

Zhu_ZhuTan — Wed, 27 Mar 2019 18:01:00 GMT

I was practicing Blueprism foundation training chapter 11. I need to read data from excel file. And I create a process to do it. .Create instance. .Show. .Open Workbook. At Open Workbook section, i don't know how to fill the filename. When I fill it by "[File Path] & "Orders.csv"", below exception is appeared. -Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. When I fill it by ""[File Path] & "Orders"", below exception is appeared. -File Not Found : File: C:\BluePrism\Training\Application\Windows\Orders does not exist or is not a file. Maybe it's a simple question, but I didn't find any related answer in the Forum, is anybody can help me how to handle it and continue it?

The second error happened…

david.l.morris — Wed, 27 Mar 2019 18:10:00 GMT

The second error happened because you need the file extension. Using this in the filename input should work assuming that [File Path] ends in a backslash \. You could use Combine Path from the File Management VBO as well. Cuts a couple steps off of checking for the backslash yourself. Don't add any quotations: [File Path] & ""Orders.csv

But use [File Path] & …

Zhu_ZhuTan — Wed, 27 Mar 2019 18:17:00 GMT

But use [File Path] & ""Orders.csv"" still bring out below error. -Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. The object MS Excel VBO is imported from Blueprism default file.

Check these things first:…

david.l.morris — Wed, 27 Mar 2019 18:20:00 GMT

Check these things first: http://portal.blueprism.com/customer-support/support-center#/path/11588…

David, really thank you very…

Zhu_ZhuTan — Wed, 27 Mar 2019 18:39:00 GMT

David, really thank you very much!! It's solved! It's the culture information setting problem. Thank you!

RE: Check these things first:…

MarcinBerdys — Tue, 28 Apr 2020 08:28:00 GMT

Can you please share the link again? This one does not work and I have encountered the same problem..

------------------------------
Marcin Berdys
IT Solution Architect
Digit.ON
Europe/Warsaw
------------------------------

RE: David, really thank you very…

AkshayaR1 — Thu, 11 Jun 2020 10:58:00 GMT

Hi Team,

Even I am getting this error File: does not exist or is not a file when trying to open a workbook from a network path. It totally work fine and fetches the excel data when manually run and throws error while scheduled.

Could somebody explain on how this was resolved?

------------------------------
Akshaya R
RPA Developer
------------------------------

RE: David, really thank you very…

sathyaDatla — Fri, 10 Jul 2020 15:39:00 GMT

Any reply on this please

------------------------------
sathya Datla
------------------------------