I can't get row item from this CSV file

[s10187967]

HI there. I am currently doing a project which requires me to read a CSV and get data from the CSV. What i have done in my Uipath is that I have used a read CSV activity to read the CSV and stored it as a data table called AppleCSV. I then tried to get row item from here

with AppleCSV.rows(0), but i encountered an error saying there is no value in position 0. Can some one help me with this?

P.s, I used python to help me get the data which is then stored in the CSV

[Pratik_Wavhal]

Hi @s10187967

Use ForEachRow Activity for reading data one by one

And within that use assign activity like shown below :-
String var = row(0).ToString

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[s10187967]

Hi, can I just check, does column index affect this activity? As I do not know when to use 0 and 1 for column index. If possible, can you provide an explanation? I am fairly new to this and trying out things on it

[Pratik_Wavhal]

Hi @s10187967

Yes. Just try by changing the Index. But what you are doing is not the way to extract the data from particular row. So i gave you the ForEachRow Activity as suggestion.

See Datatable index always start with Zero (0)
And within Excel we can see that it starts with 1

So if you are taking some counter that Starts with 1 then its equivalent to Excel.
And If you Take the ForEachRow Index then it will start with 0 i.e, der in Property Panel

Check this Sample workflow :-
MainPratik.xaml (8.7 KB)
Forum _ Rinesh.xlsx (9.7 KB)

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[s10187967]

Does this work the same with a CSV?

[Pratik_Wavhal]

Hi @s10187967

Yes. Instead of read Range use Read CSV.

Atlast it will give Datatable only and then do the same steps.

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal