HOW TO SCRAP SINGLE ELEMENT FROM THIS SITE?


I WANT THIS DATA IN EXCEL
LIKE
Frst column STORE second ADDRESS third STATE fourth CONTACT
THis should be done by data scarpping
but how could i get this city MUMBAI again n again for every row…?
Please direct me

or

@kadiravan_kalidoss
YES but how could repeat this get text output for every row/???

you have to keep it in a loop. can u provide this url.

Hi @Jay_manapure,
Use add column activity to after scraping the data and pass the default value as Mumbai.

Regards.

yes here it is https://www.intex.in/store-locator

i want in excel

Try the below approach
1.Scrape data
2. Add column activity
3. Write the Data table in excel using Write range activity.

Thanks

how it is Ca u explain??

@Jay_manapure
1.After data scrapping…Use add data column activity to add column city .
2. Then Read your datatable using read rang activity and save as dt.
3.Use For each Row and assign.
Row("‘City’)=“Mumbai”
4.Then Use write range activity to store your dt.

1 Like