Difference between revisions of "Web Automation"
(→VBA using Selenium) |
(→VBA) |
||
| Line 65: | Line 65: | ||
<youtube>sGw6r5GVA5g</youtube> | <youtube>sGw6r5GVA5g</youtube> | ||
<youtube>JPezrWwvsJM</youtube> | <youtube>JPezrWwvsJM</youtube> | ||
| + | |||
| + | * [http://gist.github.com/erajanraja24/a6b1704233c8af0b5398835dd4b21af1 Automate Internet Explorer with Excel VBA Part 3- Automatic web form filling | Rajan] | ||
| + | * [http://newtours.demoaut.com/mercuryregister.php Mecury Tours] | ||
| + | |||
| + | ==== Extreme Automation - Kamal Girdher ==== | ||
| + | |||
| + | * Live Streams... | ||
| + | <youtube>W9jug_PrEtM</youtube> | ||
| + | <youtube>5BZ6ltDfTWw</youtube> | ||
| + | <youtube>ghdzG3b7ThY</youtube> | ||
| + | <youtube>OLyY4wqnn2Y</youtube> | ||
| + | |||
| + | <youtube>Qi5CF-fKYEs</youtube> | ||
| + | <youtube>WXHD7T0D4Pk</youtube> | ||
| + | <youtube>W9jug_PrEtM</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
| + | <youtube>EPaWhqFqW6M</youtube> | ||
Revision as of 20:10, 17 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)
Contents
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
- Browser automation in Excel VBA using Selenium | Ranjith Kumar - Coding is Love
- Web Scraping – Filling in Forms | Philip Treacy
VBA
There are two ways to get information from websites programmatically: by downloading their data, or by parsing their HTML. WiseOwl
- WiseOwl Training Videos
- 46 - Querying Web Pages with Query Tables
- 47.1 - Browsing to Websites and Scraping Web Page
- 47.2 - Scraping Website Tables and Clicking Links
- 47.3 - Internet Explorer vs XML HTTP Request
- 47.4 - Logging in to a Website with Windows Security
- 47.5 - Basic HTTP GET and POST Requests
- 48 - Scraping Multiple Web Pages
- 49 - Downloading Files from Websites
Extreme Automation - Kamal Girdher
- Live Streams...
