Looping through excel to web and then back to excel

Hi everyone Im looping through excel and then I paste the info in youtube
Im getting the text from the result on youtube and writes it back in the excel’
My problem is that it takes the result from youtube and paste it into a wrong cell or the get text it self isnt copy the result the way I want
somone can help?

Hi!

Could you please show us the write range/cell activity!

How you’re writing back to the excel?

you can do that with the counter variable

Regards,
NaNi




Hi!

Your workflow will be looks like this:

CurrentRow(“singers”).ToString

Counter=1
write cell-> “B”+(Counter+1).ToString
Counter=Counter+1

This will write correctly!

Regards,
NaNi

Thank you!

Can you please explain the logic behind it ?
why it didnt work before I assigned the counter?

Hi!

If Add headers checked in read range the row index will be 2
if Add headers unchecked in read range the row index will be 1

so in the above counter we have initialized with 1(Add headers checked).
1+(Counter+1)=2 this will write the data to the 2nd row.

Regards,
NaNi

OK so I want to see if I got it right
If the headers were unchecked so the counter should of been only counter = 1 right?

Hi!

Yes, if add headers unchecked.

the scenario will be Counter=1->“B”+Counter.ToString->Counter=Counter+1

or

Counter=0->“B”+(Counter+1).ToString->Counter=Counter+1

Regards,
NaNi

thank you!

1 Like

Hi!

If you’re issue get resolved make the appropriate post as solution. it might be helpful for others.

Cheers @nirr

Regards,
NaNi

1 Like

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