i want write “Url” data in “UrlData” table and “Url” is a String variable type ,
So how can i do write “Url” data on “UrlData” Datatable
It seems you don’t have URL column. You can add column before assign activity. Use Add Data Column activity to add a column.
Thanks,
Ashok ![]()
You are doing it wrong.
So you want to write the URL from the “Url” variable from the above Get Text activity into to Urldata data table?
If so: that assign is wrong, you can’t assign something to a CurrentRow variable.
Your Urldata datatable seems to be null so maybe you forgot to build it.
Anyways you should use something like: Add Data Row → Array row → {Url} and datatable → Urldata.
I see that you have a for each row and I don’t really get what ur using it for so lets say that you are iterating through Urldata datatable and want to modify it, in that case you should you the index from the for each row and it would look something like this: Urldata.Rows(Index)(COLUMN) = Url
ok, now im explain my project , so basically i have a multiple company name and i want to extract url for all company and the bot is Working properly till “Get Text” activity and i wanna write the url in excel files so how can i do this and please mention the activity with arrow
Did you try to use Table Extraction activity for extracting the URL ?
Just asking as per your reply given.
Hi,
There are several approaches to achieve it. One of them, how about using ForEachExcelRow as the following?
Please note that this is just mock sample, and it’s necessary to modify for your requirement.
Sample20240520-1.zip (11.2 KB)
Regards,


