How to write in a particular column in excel

Hey all,

I am using the for each row loop and for a particular information, I am scrapping data from the screen using-- “Get full text” activity.
After that I want to paste that scrapped information in a particular column in excel sheet.

I want to know how to paste the scrapped information in the particular column for that row?

Thanks in advance.

1 Like

use Add Data Row inside For Each Row and pass the Get Text Output to Add Data Row like {textVar} and pass Datatable Output

and use Write Range after the For Each Row

2 Likes

Hi @ray_sha

after getting text you create a output variable(var) after
use assign activity row(“ColumnName”) = var

Regards,
Kommi Jeevan.

2 Likes

Hey all,
It worked fine.
Thank you so much

1 Like

Cheers @ray_sha if you find it useful mark it as solution and close the thread.

Hey, both the given methods work fine!

2 Likes

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