topic RE: unable to read csv file in Product Forum

unable to read csv file

RaghibEhsan — Sun, 19 Jan 2020 18:08:00 GMT

I have started consolidation exercise of foundation training and doing 1.1.2 (reading from csv file). The problem is i dont know how to read a csv file.
can anyone help?????

------------------------------
Raghib Ehsan
------------------------------

RE: unable to read csv file

vivek.kumar.goel — Tue, 21 Jan 2020 06:04:00 GMT

Multiple ways to read a csv file

1: Use Utility-File Management and action: Get CSV text as collection -- -EASIEST WAY.

2- Use MS Excel VBO , Action : Create Instance-->Open WorkBook -- > Get Worksheet as Collection (FAST).

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

RE: unable to read csv file

Carl__Carter — Tue, 21 Jan 2020 06:28:00 GMT

Hi Raghib,

The Consolidation Exercise slides in Section 11 provides full instructions for the 2 options you are expected to use to read the Orders.csv file.

These options are;

1) Open in Excel and Read the Worksheet data (Exercise 1.1.1)
2) Read as CSV file (Exercises 1.1.2)

We prefer you complete the Consolidation Exercise using the first option, however if you do not have Excel installed, then use option 2.

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------

RE: unable to read csv file

RaghibEhsan — Tue, 21 Jan 2020 11:52:00 GMT

on reaching open workbook action stage an error is coming

------------------------------
Raghib Ehsan
------------------------------

RE: unable to read csv file

Carl__Carter — Tue, 21 Jan 2020 11:57:00 GMT

You have used forward slashes in the path to the file. The Backslash should always be used in file paths when working in a Windows Desktop environment.

For example, C:\BluePrism\Training\Applications\Windows\Orders.csv.

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------

RE: unable to read csv file

RaghibEhsan — Tue, 21 Jan 2020 13:00:00 GMT

Ok sir now I have used backslash but the result is same.same error

------------------------------
Raghib Ehsan
------------------------------

RE: unable to read csv file

Carl__Carter — Tue, 21 Jan 2020 13:06:00 GMT

The error message is telling you what is wrong - the file path is not valid.

You have corrected the forward slash issue but your data item containing the file path has a double quote at the end of the path making it invalid.

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------

RE: unable to read csv file

RaghibEhsan — Tue, 21 Jan 2020 14:29:00 GMT

yes, my mistake sir.

but now I am having another problem at, Get Worksheet as collection stage, an error is coming.what should I

do?

------------------------------
Raghib Ehsan
------------------------------