How to pass screenscraped data into excel cells

[Darba]

I think this is best solution I managed to make so far:Finalmissinindex.zip (9.9 KB)

But I have to create some kind of index which jumps one cell lower every time it has typed the value. Any suggestions how? @rmunro @Madhavi

[rmunro (Rene Munro)]

@Darba, With 1 cell lower you mean skip/leave one blank cell?

[Darba]

@rmunro I mean cells B2->B3->B4 5 times so from B2 to B6… I tried Susana’s way from this thread but didnt get it to work:

Write cell for every row while looping (for each row)

@Daniel32 Inside For Each Row activity, take one Assign activity. Index = dataTableName.rows.indexOf(row)+2 Here, Index is of type interger variable.

[Madhavi (K)]

In the workflow I have sent to you, Remove Add Data Column activity in the workflow and in assign activity inside for each row, specify row(1) instead of row(“Result”)

[Darba]

Not sure did that work, but I got the write range work pretty perfectly so I kept using it.