VBA Web Scraping Selenium (google Chrome) – Hindi
VBA Web Scraping Selenium (google Chrome) – Hindi
Scrape websites on google chrome or any other browser using selenium library in VBA
Created by Ajay Parmar
Material Includes
- Lectures Files , HD video lectures with lifetime access on website.
Course Description
We are going to learn Webscraping using google chrome and it will be done using selenium library.
- Learn how to download selenium and browser drivers to first initially do the setup.
- How work with attributes like name, id using findelement methods.
- How to work with tags like A tag and its attribute href to click on the links.
- How to use class attribute and is it a good approach to use class attribute.
- how to work with Xpath to insert the data into textboxes and click on search buttons. Not just use but understand the structure of Xpath as well.
- Learn how we can change the xpath elements by their indexes.
- How to work with header tags like h1 or h2 or h3 using normal way and using xpath.
- How to run the collection loops and why we need it and when we can avoid using collection loops.
- What is difference between Web-element and Webelements and why we use set word for collection elements and not for single object.
- How to click on links on webpage using link -text and partial link text property. Based on this knowledge one mini project -how to load website by default on current date.
- How to scrape tables and its rows and rows data values and table headers.
- Collection loops design and execution from very start while working with tables.
- Do you like to export all tables in a website or do you want to scrape one specific table only, How to reach out to specific index of a table then.
- How to scrape specific rows inside one specific table . Know your “tr’ tags.
- How to scrape all data insider rows or just one specific data value using td tag. Its awesome when you have so much control.
- How to export tables with out running collection loops and what is the difference between direct export and export using loops. You must know.
- How to work with li tags inside unordered and ordered lists.
- Know how to insert a value in drop down or combo-boxes .
- How to select items in list box with single select property or multi select property.
- Learn to select or de-select listbox options using collection loops or without the loops.
- How to alter the collection elements by referring to one object and second inside the first one and so on.
- Students will learn how to download the files
- How to add or manage Cookies of a website and how to use it in a practical situation.
- How to take screenshots and save those on desktop or export them in excel.
- How to launch website new pages in a new window tabs.
- Move from first window to second and so on. Challenges and more robust solutions to handle the window tabs.
- You will see one of the real data based project which is super duper awesome from learning and getting confidence on webscraping.
- We will see how to login to website and how to sort out captcha issues by simply letting code to wait for sometime till user enters captcha.
- We will revise our learning in part1 as to how to practically use links using elementbyid, name or class attributes . Also, the best use of Xpath.
- if page refreshes for a long time or uncertain , how to put a wait time.
- You will see the use of magnificent loops and IF Conditions on this project . How smartly we have used the loops and IF Conditions and clicking on elements.
- In this project you shall see how to fully control the website elements like drop downs or a tags from excel lists which are written on sheets.
Course Curriculum
Let us start
-
Selenium libraries download and introduction
33:20 -
Work with the ID attribute
16:12 -
Work with name attribute
08:16 -
Class attributes
11:27 -
Know a tags collection Loop
34:15 -
Work with Tables
39:09 -
Work with Tables continues
48:18 -
More on tables
05:42 -
tables and Xpath
49:13 -
List Tags and Partial link
23:50 -
Drop Downs on website – how to select
30:43 -
ListBox – How to work
23:05 -
Check if element exists
06:41 -
Cookies -Store data
14:03 -
Project for you – Bonus
22:49 -
Project Part2
17:10 -
Part3
21:18 -
Part4
16:42 -
Part5
08:30 -
Project finished Part6
09:45 -
Student problem is solved – Dates selection
08:29
₹899.00
₹2,500.00
-
LevelAll Levels
-
Total Enrolled66
-
Duration10 hours
-
Last UpdatedFebruary 8, 2023
Hi, Welcome back!
VBA Web Scraping Selenium (google Chrome) – Hindi
₹899.00
₹2,500.00
-
LevelAll Levels
-
Total Enrolled66
-
Duration10 hours
-
Last UpdatedFebruary 8, 2023
Material Includes
- Lectures Files , HD video lectures with lifetime access on website.
Course Description
We are going to learn Webscraping using google chrome and it will be done using selenium library.
- Learn how to download selenium and browser drivers to first initially do the setup.
- How work with attributes like name, id using findelement methods.
- How to work with tags like A tag and its attribute href to click on the links.
- How to use class attribute and is it a good approach to use class attribute.
- how to work with Xpath to insert the data into textboxes and click on search buttons. Not just use but understand the structure of Xpath as well.
- Learn how we can change the xpath elements by their indexes.
- How to work with header tags like h1 or h2 or h3 using normal way and using xpath.
- How to run the collection loops and why we need it and when we can avoid using collection loops.
- What is difference between Web-element and Webelements and why we use set word for collection elements and not for single object.
- How to click on links on webpage using link -text and partial link text property. Based on this knowledge one mini project -how to load website by default on current date.
- How to scrape tables and its rows and rows data values and table headers.
- Collection loops design and execution from very start while working with tables.
- Do you like to export all tables in a website or do you want to scrape one specific table only, How to reach out to specific index of a table then.
- How to scrape specific rows inside one specific table . Know your “tr’ tags.
- How to scrape all data insider rows or just one specific data value using td tag. Its awesome when you have so much control.
- How to export tables with out running collection loops and what is the difference between direct export and export using loops. You must know.
- How to work with li tags inside unordered and ordered lists.
- Know how to insert a value in drop down or combo-boxes .
- How to select items in list box with single select property or multi select property.
- Learn to select or de-select listbox options using collection loops or without the loops.
- How to alter the collection elements by referring to one object and second inside the first one and so on.
- Students will learn how to download the files
- How to add or manage Cookies of a website and how to use it in a practical situation.
- How to take screenshots and save those on desktop or export them in excel.
- How to launch website new pages in a new window tabs.
- Move from first window to second and so on. Challenges and more robust solutions to handle the window tabs.
- You will see one of the real data based project which is super duper awesome from learning and getting confidence on webscraping.
- We will see how to login to website and how to sort out captcha issues by simply letting code to wait for sometime till user enters captcha.
- We will revise our learning in part1 as to how to practically use links using elementbyid, name or class attributes . Also, the best use of Xpath.
- if page refreshes for a long time or uncertain , how to put a wait time.
- You will see the use of magnificent loops and IF Conditions on this project . How smartly we have used the loops and IF Conditions and clicking on elements.
- In this project you shall see how to fully control the website elements like drop downs or a tags from excel lists which are written on sheets.
Course Curriculum
Let us start
-
Selenium libraries download and introduction
33:20 -
Work with the ID attribute
16:12 -
Work with name attribute
08:16 -
Class attributes
11:27 -
Know a tags collection Loop
34:15 -
Work with Tables
39:09 -
Work with Tables continues
48:18 -
More on tables
05:42 -
tables and Xpath
49:13 -
List Tags and Partial link
23:50 -
Drop Downs on website – how to select
30:43 -
ListBox – How to work
23:05 -
Check if element exists
06:41 -
Cookies -Store data
14:03 -
Project for you – Bonus
22:49 -
Project Part2
17:10 -
Part3
21:18 -
Part4
16:42 -
Part5
08:30 -
Project finished Part6
09:45 -
Student problem is solved – Dates selection
08:29