Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel XML, XPath and XSLT Workflows

Video Introducing this tutorial


1. Getting Started :
Welcome to Excel XML, XPath and XSLT Workflows
2. Download the course files here

2. XML Essentials :
1. What is XML
2. Structure of an XML document
3. Elements
4. Attributes
5. Entity references
6. CDATA sections
7. Comments
8. Processing instructions
9. XML Validation
10. Well-formed XML
11. Overview of DTDs
12. Overview of XML schema documents

3. Excel and XML :
1. Importing XML into Excel
2. Creating an XML map
3. Importing XML data incrementally
4. Validating XML data
5. Multilevel import multiple tables
6. Multilevel import single table
7. Exporting XML data

4. WEBSERVICE, FILTERXML and XPath :
1. Using the WEBSERVICE function
2. XPath overview
3. Using FILTERXML and ENCODEURL
4. Using FILTERXML with local XML files
5. Using predicates
6. The new CONCAT function
7. Descendant-or-self axis

5. Using XSLT stylesheets :
1. XSLT and Microsoft Excel
2. Creating new elements
3. Using xsl-copy-of
4. Using xsl-text and xsl-value-of
5. Creating new attributes
6. Using xsl-if
7. Using xsl:choose
8. Using attribute value templates