For Each Loop updating website

Help
1

Afternoon, me again…

I have downloaded a csv
used a Read CSV into a datatable

now its the For Each part im stuck on
I need it to for each row >> take column 1 paste it in to a browser > enter column 2 into page that appears copy over column 2, then start again with the next row
I know I need to have a variable with a count of rows (i think) so that it doesn’t just keep looping. but the rest im stuck on

image
image366×595 20 KB

2

@Jersey_Practical_Sho Upoload.Rows(1).Items(1) what it means?

3

that was just something ki was trying

upoload was a spelling mistake i made when creating the variable “upload” I was seeing if I could get it to simply use the data from row 1 item 1

4

@Jersey_Practical_Sho You can use like below

row(0).toString

It will give 1st column values everytime loop runs.

5

Thankyou

but it doesn’t enter any information into the browser box

6

@Jersey_Practical_Sho may be problem with typeinto activity or u may dont have in that row for that column.

display the row(0).tostring to check whether datatable has value or not.

7

Ive found a solution that will work for me but…

when reading the solution they have .Rows at the end of the table name as below
image
But When I do I get the blue exclamation mark
If I leave .Rows off, then the exclamtion mark goes away but my write line outputs nothing

8

@Jersey_Practical_Sho Remove .Rows in dtTasks.Rows. It will work

9

now that what I thought but it wasn’t doing anything still (it was part of the problem)
It was actually the format of the CSV that I saved in excel I changed to (MS-DOS) type and now it all works, thanks for your help

10

@Jersey_Practical_Sho can u share screenshot of previous activity from where u getting data to dtTasks variable

11

image
image1215×368 13.4 KB

12

@Jersey_Practical_Sho what is variable type of dtTasks? if it is dataTable Type. if It is dataTable type remove .Rows and let me know what u getting

13

all working now :smile: