unable to read csv file

[RaghibEhsan]

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

[VivekGoel]

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

[Carl__Carter]

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

[RaghibEhsan]

on reaching open workbook action stage an error is coming

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

[Carl__Carter]

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

[RaghibEhsan]

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

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

[Carl__Carter]

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

[RaghibEhsan]

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