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.


 


Comments

All comments about this page:


Comment by: JackL (10-2-2009 05:53:42) deeplink to this comment

Thanks for an excellent article.


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].