Microsoft® Office Excel 2003 Programming Inside Out

Chapter 26. Excel and the Extensible Markup Language (XML)

Introducing Data Lists

Creating XML Schemas

Creating XML Data Files

Adding XML to a Workbook Manually

Adding XML to a Worksheet Programmatically

Support for XML, including the ability to save files as XML documents, was introduced in Microsoft Office XP, but the technology is one of the focal points of Office 2003. If you work in an enterprise that exchanges data with other organizations in the form of purchase orders, parts data, financial data, or product catalogs, you can use XML to transfer the data among your colleagues and suppliers regardless of the program used to create the data.

In this chapter, you’ll learn how to:

• Create data lists manually and programmatically

• Create XML schemas and ...