|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/vba-selenium-web-scraping-part-22/
课程评论：没有评论
课程名称：VBA Selenium网络爬虫第2部分 课程概述：本课程为第2部分，学生需先完成第1部分的学习。学员将学习如何下载文件、管理网站的Cookies以及在实践中应用这些知识。课程将指导学员截取网站页面的屏幕，并将截图保存到桌面或导出到Excel中。此外，学员将学习如何在新窗口标签中启动网站新页面，并在多个窗口之间切换，处理标签页的挑战及更稳健的解决方案。课程还将展示一个实际的数据项目，让学员在学习和增强网络爬虫信心方面受益匪浅。 学员将学习如何登录网站，并处理验证码问题，通过让代码等待用户输入验证码的方法。在课程中，学员会复习第1部分的知识，学习如何使用ID、名称或类属性的链接，并掌握XPath的最佳用法。如果页面加载较慢，学生还将了解如何设置等待时间。学员将看到循环和IF条件的巧妙应用，以及如何智能地点击元素。 在这个项目中，学员将学习如何完全控制网站元素，如下拉菜单和基于Excel表单的标签。课程还将跟踪已完成的工作状态，确保在下次代码运行时跳过已完成的部分。 课程大纲：无
First and foremost, this is a Part2. Students must have seen Part1 before.Students will learn how to download the filesHow 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.How so far work done is going to be noted in excel sheet marking status as Done so next time when code runs it avoids previous already done codes.
