Jump to content



Photo

Scrape To Excel-File?


  • Please log in to reply
1 reply to this topic

#1 SweTech

SweTech

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 54 posts
  • LocationStockholm
  • OS:Windows Vista
  • Total Memory:< 1Gb
  • Framework:v3.5 & v4.0
  • License:Professional Edition

Posted 21 June 2019 - 04:41 AM

Hi!

Would this be achievable with Ubot Studio and if so, how?

Thanks :)
 
------
1. Load a list of names from an Excel-file
2. insert first name from list into a url and then visit the url
3. Scrape some data
4. Save data in a table
5. Insert second name from list into url...
6. loop while there are names left
7. Export data to Excel


#2 hare ram

hare ram

    Advanced Member

  • Members
  • PipPipPip
  • 127 posts
  • LocationNew Delhi
  • OS:Windows 10
  • Total Memory:8Gb
  • Framework:v4.0
  • License:Professional Edition

Posted 21 June 2019 - 05:12 AM

I send a demo code how you can start from these steps you have to edit some where in loop how you can save data you have to define variables that data does not crashed together you set these thing according to your need:

 

ui open file("Name",#name)
clear list(%name)
add list to list(%name,$list from file(#name),"Delete","Global")
loop($list total(%name)) {
    navigate("your url{$next list item(%name)}","Wait")
    wait(3)
    clear list(%scrape)
    add item to list(%scrape,$scrape attribute(<id="upgrade_notif_header">,"name"),"Don\'t Delete","Global")
    add list to table as column(&scrapeddata,0,0,%scrape)
}
save to file("{$special folder("Application")}\\Your scraped data.csv",&scrapeddata)






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users