How to get value with different col in a row from each row of a sheet?

Help Studio
, ,
1

Hello all,

I am an UiPath beginner trying to retrieve data from excel sheet with col [C,D,E] of each row in a sheet and paste the value to a webpage.

How can I retrieve each cell value? First, get the red frame cells each and paste to webpage. Then, get the green frame cells and so on for the last rows.

image
image741×281 9.88 KB

2

Hello @yanlinc

First off you would use a Read Range activity (Excel/Workbook) to read the Excel file.
After this you should use a For Each Row in Data Table activity to loop the individual rows.

Inside this loop is where you would put the interactions with the website - eg. Type Into, Click etc.
To reference the individual column values within your current row, you can either define the Column Index (remember this starts at 0) or the Column Header.

Example:

CurrentDatarow(2).ToString
or
CurrentDatarow("Name").ToString

Regards
Soren

3

Hi @SorenB ,
Thanks for sharing this info. Helps me a lot.
My flow currently works well.

1 Like
4

No problem :slightly_smiling_face:
Feel free to reach out if you have any more questions.

Regards,
Soren

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.