Convert string (URL) to datatable

[Luqman (Luqman Adenan)]

Hi,

How do I convert string from browser to data table that can be transfer into excel? I’ve tried to use write range activity but it keeps on writing on the same cell. My problem is that, I extract URL from web browser then whenever i want to write in the excel file, the extracted data overwrite on the same cell without moving to the row below.

[skini76]

Please share the code…

[Pankaj.Patil (Robot Master)]

Hello,

Use data scraping. it generates datatable.

Thanks,
Pankaj

[Luqman (Luqman Adenan)]

what code?

[Luqman (Luqman Adenan)]

I want to scrape this webpage url. if i use data scraping, I could only scrape the picture url but not the webpage url. So, i use ‘get attribute’ activity. I managed to scrape it but whenever I want to put it in the Excel, the last data will overwrite the first data(url).

Thanks.

[Pankaj.Patil (Robot Master)]

Hello,

oh, i see
no really time to make an example
Please go through the below link

Append Range

Thanks,
Pankaj

[Luqman (Luqman Adenan)]

Thanks for the help Pankaj.

[Uthraa]

Refer the below work flow.
excelRead.xaml (9.0 KB)

Thanks.

[Luqman (Luqman Adenan)]

Thank you uthraa

[Luqman (Luqman Adenan)]

I’ve found the solution which is I need to make 2 different “Excel Application Scope” activities, one for Write Range and another one is for Append Range. Use the same steps: For Each Row, Open Browser, Type Into, Get Attribute(URL), Build Data Table, Add Data Row, For Each Row(Write Range or Append Range).