Introduction
This article has been previously published in the Dutch Microsoft
Office Magazine no 27, 2006.
Microsoft Office 2003 Professional was the first Office version that
took the XML standard seriously. The XML standard has been devised to
ease the markup of data (especially on the web). A well known example of
the use of XML are RSS feeds with which one can gather news from web
pages. In reality, these so-called RSS-feeds are nothing less than XML
files. This article introduces XML and shows some things that can be
done with it (specifically in Excel).
Note : In this article techniques are used which are only available
in all Excel 2007-2021, 365 versions and in the "stand-alone" versions of
Excel.
The sample files from this article may be downloaded
here.
Contents
-
What is XML
-
Characteristics of XML
-
Structure of XML
-
XML Schemas
-
XML in Excel
-
XML Validation
-
Conclusion