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
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
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
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
kindly try with this steps as you told we need to get the datatable for each and every row in sequence
Cheers @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
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