Difference between revisions of "Web Automation"

Revision as of 17:00, 16 November 2019

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)

@@ Line 37: / Line 37: @@
 [http://www.google.com/search?q=Web+scraping+Automation+Excel ...Google search]
-* [http://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw WiseOwl Training Videos]
 * [http://automatetheweb.net/ AutomateTheWeb.net]
+=== VBA using Selenium ===
 * [http://codingislove.com/browser-automation-in-excel-selenium Browser automation in Excel VBA using Selenium | Ranjith Kumar - Coding is Love]
+=== VBA ===
+* [http://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw WiseOwl Training Videos]
+** [http://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/web-query-tables/ 46 - Querying Web Pages with Query Tables]
+** [http://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/scraping-web-pages/ 47.1 - Browsing to Websites and Scraping Web Page]
+** [http://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/scraping-web-tables/ 47.2 - Scraping Website Tables and Clicking Links]
+** [http://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/ie-vs-httprequest/ 47.3 - Internet Explorer vs XML HTTP Request]
+** [http://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/login-windows-security/ 47.4 - Logging in to a Website with Windows Security]
+** [http://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/scraping-multiple-web-pages/ 48 - Scraping Multiple Web Pages]
 <youtube>ZrPEAljQjRM</youtube>