|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/web-scraping-using-excel-vba/
课程评论：没有评论
课程名称：使用Excel VBA进行网页抓取 课程概述： 网页抓取是指如何从任何网站获取信息，而无需手动处理。通过本课程，您将学习如何使用Internet Explorer下载网站数据、点击按钮，以及获取段落内容、表格内容等。这门课程将教您如何通过自动化来完成网页操作，再也不需要手动处理。请注意，本课程只能在Internet Explorer上进行。 课程内容涵盖了循环使用和条件判断在VBA网页抓取中的应用。课程适合从基础到高级的学习者，但不包括VBA的基础知识。具体内容包括： - 如何处理A标签 - 如何处理类标签以及类标签的定义 - 在处理类时可能遇到的问题 - 如何处理输入标签和ID标签 - 什么是HTML中的类，以及如何和为什么创建它们 - 文档及其类和文档元素的对象层次结构讨论 - 如何在网站中点击链接 - 如何填写网站表单 - 如何从互联网下载Excel或CSV文件 - 课程中会有作业供您练习 - 如果在网页上无法点击链接，如何调试程序 - 使用立即窗口查看标签（如A标签、ID、Class、输入、标题等）的更多属性 - 从网页中导出表格细节到Excel - 如何处理已打开的网页 本课程非常实用，适合希望掌握网页自动化技术的学习者。
Webscraping means how to get the information from any website without doing any manual handling.You will be able to download the data from a website or click on buttons or get the paragraphs content, tables contents and so much.This course will teach you how to do the Web Automation via Internet Explorer - No more manual stuff. It can be done using automation now. Please note it is going to be done only by internet explorerLearn every thing about loops use and if conditions in Web Scraping using VBA in internet explorerThis course is Basic to Advance Level Course so you can definitely join it but it does not discusses vba basics.How to work with A tagsHow to work with Class Tags and what are the class tags. What type of issues one can face while dealing with classes is also something we have discussed.How to work with input tags,ID tagsWhat is a class in HTML and how and why we create them in HTMLWhat is a document , its class and document elements - object hierarchy discussionHow we can click on links in websiteHow to put the information in website forms How to download the excel or csv files from internetAssignments for you to practiceHow to debug the program if you are not able to click on link despite it is available on web pageUse of immediate window to see more properties of tags like A tag,ID,Class,input, headers etc.Export tables details in excel from a web pageHow to work with already opened web-pages
