Data scraping from website with multiple searches items from different states and countries

Hello Everyone,
i trying to data scrap an information from a website by selecting cities from CSV file and automating the process till the last data is copied from CSV

can any one suggest me how to perform such task

1 Like

Fine
hope these steps would help you resolve this
–use READ CSV activity and pass the file path of csv file as input and get the output with a variable of type datatable named outdt
–then use a for each row loop and pass theabove variable asinput
–inside the loop use a open broswer activity and pass the url of the web page from where we want to get the datatable
–inside the do container of open browser, use a DATA SCRAPPING method from design tab in studio and scrape the datatable and get the output with a variable of type datatable named dt
–if we want to store the datatable in a excel use a excel application scope and write range activity within it where we can pass the dt variable as input
while in excel file path mention as
“excelfilenamewithoutextension”+Now.ToString(“hh_mm_ss”)+“.xlsx”
this will create new file for each data scrapping inside the project folder

Hope this would help you
Cheers @vijayalakshmi8

Hi @vijayalakshmi8

You mean to say that you have a csv file with column as City based on data scrapping you need to scrap and then write the data in csv is that right?

Thanks
Ashwin S

States and Cities of USA.xlsx (16.3 KB)

this is my csv file from which i have to copy that data into an web site where i can data scrap from the results i have got and it need to repeat for each and every row of my entire file

thanks for the reply @AshwinS2

\

this is how i used and below are the properties which i have used

kindly try with this steps as you told we need to get the datatable for each and every row in sequence
Cheers @vijayalakshmi8

Hi @vijayalakshmi8

is the file in csv or xlsx
if xlsx means do the scrapping and then do the write range based on iteration
Thanks
Ashwin S

xlsx but i saved in csv format

Hi @vijayalakshmi8

Have a try i think @Palaniyappan steps should work :slight_smile:

Thanks
Ashwin S

1 Like

is this correct which im trying??

Kali.xaml (10.4 KB)
didn’t include data scraping

this is what i want can you verify @Palaniyappan @AshwinS2

try.xaml (24.8 KB)

this is my activity can you guys verify it once @Palaniyappan @AshwinS2
thanks in advance