|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/vba-web-connect-excel-to-the-web-with-vba/
课程评论：没有评论
课程名称：VBA WEB - 使用VBA将Excel连接到WEB 课程概述：VBA曾被认为是一种被遗忘的语言，但新的功能和对象的出现使得它能够实现微软Office产品与网络之间的数据交换。如今，VBA提供了发送HTTP请求、接收HTTP响应及解析结果的功能，包括DOM、XML解析、JSON解析、XML XPath、VBA正则表达式、ADODB连接SQL Server和mySQL数据库、在VBA表单中嵌入网页浏览器等功能。 本课程为初学者提供了Excel、Visual Basic for Applications（VBA）和HTML的基础知识。学生将在课程中学习以下内容： - HTML DOM及HTML编辑工具 - 在VBA中打开网页，创建基于Excel工作表的HTML表格，创建包含目录的HTML文件 - 从网站下载文件，使用VBA抓取网站数据，将HTML表格数据展示到Excel - 使用VBA代码从网站提取数据，包括使用ServerXML和XMLHttp进行HTTP请求和响应解析 - 使用InternetExplorer对象读取网页数据，获取HTML元素 - 动态输入HTML表单数据，触发事件，处理人性化信息和机器友好消息 - 将JSON和XML文件导入Excel，导入网页数据，利用Web查询和VBA嵌入浏览器 - 通过VBA实现SOAP Web Service请求，进行REST调用，连接和查询SQL Server和mySQL数据库 - 发送HTML邮件，展示RSS Feed，并从Bing搜索获取数据展示结果 - 使用Google Maps进行地址地理编码，计算行程持续时间和距离，解析HTML代码中的字符串 此课程将为学员在Excel中利用VBA实现与WEB的深度连接提供全面的知识与技能。
VBA was considered a dead language until new functionalities and objects have been made available to enable data exchange between MS Office products and the Web.Today VBA offers functions to send HTTP requests, receive HTTP responses and parse the final results using technologies and objects e.g. DOM, XML parsing, JSON parsing, XML XPath, VBA Regular Expressions, ADODB connections to SQL Server and mySQL Databases, generate Web Browsers to embed into VBA forms and much more.Before into details I have included some lectures for those that are new to understand and get to know Excel, Visual Basic for Applications (VBA) and HTML.The students will learn the following in this course:HTML DOM HTML editing toolsOpen a Web page in VBACreate HTML Tables with from Excel Worksheets with VBA Create HTML Files with a Table of Contents based on Cell DataDownload File from Website Using ExcelScraping data from website using vbaGet data in an HTML table and display in an Excel fileGet all the data in an HTML table and display in an Excel fileVBA Code - To extract data - From website to Excel Macro with ServerXMLHTTPScraping a website HTML in VBA using the HTMLDocument objectRead data from a website using VBA web queryImport Website data to ExcelEmbed a browser in an Excel VBA formIdentify information on a Web Page and display it in human readable wayProcessing human friendly messagesGenerate machine-friendly messagesImport JSON to ExcelImport an XML file into ExcelGet data from the webUse the InternetExplorer Object to get Data from the WebUse the InternetExplorer object to get elements of an HTML tableRetrieve single HTML elements using the InternetExplorer objectParse and submit an HTML form using the InternetExplorer objectTrigger events of elements using the InternetExplorer objectClick on a button and trigger the associated event using the InternetExplorer objectEnter data dynamically into an HTML form using the InternetExplorer objectUse XMLHttp to send HTTP requests, receive HTTP responses and parse the contentUse ServerXMLHttp to send HTTP requests, receive HTTP responses and parse the contentUsing ServerXMLHTTP to GET XML results from a Web pageUsing ServerXMLHTTP to POST XML to a Web pageProviding authentication info via msxml2.ServerXMLHTTP (use JustGiving API)Scrape html by element id, name after response using msxml2.ServerXMLHTTPSave MSXML2.ServerXMLHTTP Response text is an HTML PageExtracting data from the response of a serverXMLHTTP requestExtract a table of data from a website using a VBA queryPull data into Microsoft Excel with Web queriesImport HTML content in Excel with Query TablesImport HTML table with Web QueryInvoke a SOAP Web Service from custom VBA CodeDo a SOAP Request in VBAUse VBA to send XML to WSDLCreate a SOAP Request/Response using XML from VBAGet Http Request In Excel VbaBuild a VBA App from calling an APIMake REST call with VBA in Excel: WinHttpSend HTTP requests with VBA from Excel with WinHttpGet Http Request In Excel Vba with WinHttpGet JSON Response with WinHTTP in VBAInstall and configure SQL Express Server and the Management tool for testingConnect to a remote SQL Server DB With VBA & ADODBUse Excel VBA to Query a SQL Server DatabaseInstall and configure a mySQL Database for testingConnect to remote MySQL DatabaseConnect to MySQL database in Excel with VBA and get the dataSend HTML Email from Excel using VBAShow RSS Feeds in ExcelRead RSS feeds from VBA create an rss feed with Excel VBAGet Data from Bing Search and display the results using DOMDisplay google maps on a UserFormCalculate durations and distances of itineraries from Google Maps with VBARetrieve Address Geocoding with VBA and Google MapsParse strings from HTML code via VBA code using RegEx...
