Reading CSV and iterating through the values?

datatable
excel
loop

#1

Does anybody have an example of reading a CSV file and parsing each row/column? I’m trying to put together a simple project that will read two columns from a CSV and then use the variable values to repeat a task in a browser. The second half I know how to do, but setting up to read the CSV is turning out to be tricky.

https://www.uipath.com/kb-articles/how-to-read-data-from-a-csv-file — the example file here doesn’t seem to work? The extension is UIWF. I changed it to XAML and it opened but only one of the steps was able to be loaded.

The user guide that UiPath has on YouTube is also (apparently) a very old build with some significant differences, so I’m at a loss as to how to set this up. I keep getting format errors that I’ve tried to troubleshoot but to no avail. A working example file would be fantastic.


How to make process repeat but for next record in application?
#2

Hi @indyproject

Please find attached workflow. :slight_smile:

Solution.zip (2.4 KB)

Regards…!!


#3

How would you iterate through a list of numbers in a CSV file and then find the highest value and save it to a notepad doc??


#4

hi,
Please follow the below tutorial,

Thanks,
Karthik.


#5

Hi Akshay,

Help me on this.

In the given example,If the given column name is dynamic how to read the excel.

Column name is dynamic ,But it is always first column in the excel.

Thanks.


#6

Hi All,

Help me on this.

In the given example,If the given column name is dynamic how to read the excel.

Column name is dynamic ,But it is always first column in the excel.

Thanks.


#7

@shiva252 row(0) will give first column values


#8

Will try.Tq Manju.