Mega offers:17 Courses in 4500 Rs(550Hrs), 10 Courses in 3500Rs

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:43
  • 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:06
  • Check if element exists
    06:41
  • Cookies -Store data
    14:03
  • Project for you – Bonus
    22:50
  • Project Part2
    17:10
  • Part3
    21:19
  • Part4
    16:42
  • Part5
    08:30
  • Project finished Part6
    09:45
  • Student problem is solved – Dates selection
    08:29
Original price was: ₹2,500.00.Current price is: ₹899.00.
899.00 2,500.00

VBA Web Scraping Selenium (google Chrome) – Hindi

Original price was: ₹2,500.00.Current price is: ₹899.00.
899.00 2,500.00

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:43
  • 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:06
  • Check if element exists
    06:41
  • Cookies -Store data
    14:03
  • Project for you – Bonus
    22:50
  • Project Part2
    17:10
  • Part3
    21:19
  • Part4
    16:42
  • Part5
    08:30
  • Project finished Part6
    09:45
  • Student problem is solved – Dates selection
    08:29