XML and Excel

Pages in this article

1. What is XML
2. Characteristics of XML
3. Structure of XML
4. XML Schemas
5. XML in Excel
6. XML Validation
7. Conclusion

Conclusion

This article has only scratched the surface of what XML is and what its possibilities are. For example I haven't addressed the information sharing options XML offers: it greatly eases the re-use of data across platforms. Below I have collected some resources with more information on XML.

References

XML

http://www.w3.org/XML/

MSDN and XML

http://msdn.microsoft.com/xml/

Schemas

http://www.w3.org/TR/xmlschema-0/

Extensible Stylesheets

http://www.w3.org/Style/XSL/

About Excel and XML

https://support.office.com/en-us/article/overview-of-xml-in-excel-f11faa7e-63ae-4166-b3ac-c9e9752a7d80

Books

Professional Excel development
By Stephen Bullen, Rob Bovey and John Green
Published by Addison-Wesley, februari 2005.
ISBN: 0321262506

Downloads

Download the sample files of this article.