|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-xml-xpath-and-xslt-workflows/
课程评论：没有评论
**Excel XML, XPath 与 XSLT 工作流课程总结** **课程概述:** 本课程是一门在 Udemy 上广受欢迎的课程，专注于 Microsoft Excel 中与 XML 相关的强大功能。课程适合对 Excel formulas 已经有一定了解，但对 XML、XPath 及 XSLT 完全陌生的学习者。通过循序渐进的教学，课程将演示如何利用 Excel 的 XML 功能处理复杂的数据工作流。 **课程亮点:** * **Excel 与 XML 的深度结合:** 深入解析 Excel 作为一款“XML 感知”应用的特性，包括其对 XML、XPath 和 XSLT 的支持。 * **XML 基础入门:** 从 XML 的基本概念、文档结构、DTD 和 Schema（用于 XML 验证）入手，帮助零基础学员快速掌握 XML。 * **Excel 数据导入与导出:** 详细讲解如何在 Excel 中导入和导出 XML 数据，重点介绍 XML 映射（XML maps）和 XML 表（XML tables）的概念，以及如何利用 Schema 文档进行数据验证。 * **在线 XML 数据处理:** 教授如何使用 Excel 的 `WEBSERVICE`、`FILTERXML` 和 `ENCODEURL` 函数从在线 Web 服务下载 XML 数据，并运用 XPath 提取所需信息。 * **`FILTERXML` 的本地数据应用:** 提供创新的方法，展示如何运用 `FILTERXML` 函数处理本地 XML 文档，突破其原有的在线限制。 * **XML 数据转换 (`XSLT`):** 揭示 Excel 中隐藏的 XSLT 功能，讲解 XSL 样式表的构建方法，以及如何在样式表中使用 XPath 定位和转换 XML 数据，实现数据导入时的即时转化。 **学习目标:** 完成本课程后，学员将能够自信且高效地处理各种 Excel XML 相关工作流。 **学习者评价:** 学员普遍反映讲师讲解清晰、内容实用且难度逐步提升。课程独特地展示了 Excel 鲜为人知的 XML 功能，提供了许多难以通过网络搜索获得的实用技巧，并帮助学员全面理解 XML、XPath 和 XSLT 的概念。
This is a Udemy best-selling course. Here are some of the comments from other students:"Excellent instructor. The lessons are clear, practical and gradually increase the complexity. I had just a basic knowledge of XML and after this course I am learning a lot more.""A very useful and unique insight into a lesser known area of Excel. I picked up a lot of tips that I probably wouldn't have been able to find by Googling. I also feel I have learned a lot about XML, XPath and XSLT, just in general terms, and not just in the context of Excel."...Microsoft Excel is a very XML aware application, featuring not only XML, but also XPath and XSLT capabilities; and this intermediate/advanced Excel course explains all of Excel's XML-related features in depth. The course assumes a good familiarity with Microsoft Excel and the use of Excel formulas. However, no knowledge of XML, or its related technologies, is assumed. The course begins with an overview of the nature of XML and itemizes the different objects which can form part of an XML document. This introductory section also explains the use of DTDs and schema documents to validate XML. We then move on to look at the importing and exporting of data into and out of Microsoft Excel. We discuss the creation of XML maps and how they relate to XML tables, as well as the validation of XML data, using schema documents, both on import and export. Next, we explore online XML, as we use Excel's WEBSERVICE, FILTERXML and ENCODEURL functions to download XML data from online web services and use XPath statements to extract the information we want from the downloaded XML. Although FILTERXML and its XPath statements are designed to work only with online web services, this course will show you a crafty workaround which will enable you to use this function to extract data from your local XML documents as well. The final section of this course is given over to an XML capability which is well hidden in Microsoft Excel, namely the ability to transform XML as you import it by using XSL stylesheets. The course provides an overview of how XSL sheets are constructed and how XPath is used within stylesheets to target the different parts of the input XML document which you want to transform and include in the output. In short, whatever Excel XML workflows you are faced with, this course will equip you to deal with them confidently and efficiently.
