Difference between revisions of "Web Automation"
(→Excel with VBA) |
(→Excel with VBA) |
||
| Line 33: | Line 33: | ||
<youtube>n188_5d9Zgo</youtube> | <youtube>n188_5d9Zgo</youtube> | ||
| − | == Excel | + | == Excel == |
[http://www.youtube.com/results?search_query=Web+scraping+Automation+Excel YouTube search...] | [http://www.youtube.com/results?search_query=Web+scraping+Automation+Excel YouTube search...] | ||
[http://www.google.com/search?q=Web+scraping+Automation+Excel ...Google search] | [http://www.google.com/search?q=Web+scraping+Automation+Excel ...Google search] | ||
* [http://automatetheweb.net/ AutomateTheWeb.net] | * [http://automatetheweb.net/ AutomateTheWeb.net] | ||
| + | * [http://www.wiseowl.co.uk/blog/s2554/import-web-table.htm Getting data in Excel without coding VBA to scrape a website use Power Query | WiseOwl] | ||
=== VBA using Selenium === | === VBA using Selenium === | ||
Revision as of 17:05, 16 November 2019
YouTube search... ...Google search
- Web Automation with Python
- Requests ...simple HTTP library for Python
- Beautiful Soup - bs4 ...for parsing HTML and XML documents. It creates parse trees
- Scrapy ...open source and collaborative framework for extracting the data you need from websites
- Selenium ...a web testing library. It is used to automate browser activities.
- Regular Expressions (Regex)
Beautiful Soup and Requests
Jupyter Notebook
YouTube search... ...Google search
- Web Scraping Guide | StrataScratch ...web scraping in Python with Beautiful Soup
- Using Selenium with Google Colaboratory | Darek Tidwell
Excel
YouTube search... ...Google search
- AutomateTheWeb.net
- Getting data in Excel without coding VBA to scrape a website use Power Query | WiseOwl
VBA using Selenium
VBA
