Copying data from website to each excel column for each row

Learn Academy Feedback
#1

I have filled out a form and now i need to copy the data from the website into my excel sheet. So i use data from column A-B to fill the form now I need to write the returned data into column C. I have tried to save the data in a Varible then parse it using the assign activity. I am new to UiPath so i can only upload one screenshot

(upload://8dIk6uLGlz7VPb663ekNuNQQHLW.png)

#2

uipathfour
uipathfour564×546 11.4 KB

#3

uipaththree
uipaththree516×610 18.7 KB

#4

uipathtwo
uipathtwo560×598 27.3 KB

#5

uipathone
uipathone507×597 17.9 KB

#6

You can use write cell activity to write value into excel cell.
you have to use excel application scope first which will open your excel file and inside it use write cell activity.

Hope it will works.

writecell

1 Like
#7

Thanks for the help I can get it to write it all in one cell but not write it individually for each row.

I tried to use "F"index.ToString as each row needs its own value (example a1 + b1 = c1 then a2 + b2 = c2). however I think i have some syntax error.

row.index
row.index1424×631 24.9 KB

#8

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