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