Programming Excel with VBA and .NET

Chapter 15. Working with XML

As you may have realized from the previous chapter, lists are one of the ways Excel handles XML data. Shared lists are stored as XML, SharePoint exchanges updates via XML Web Services, and lists can import and export XML.

Warning

The Excel features covered in this chapter apply to Office 2003 for Windows. Earlier versions and Macintosh versions of Office do not support these features, although Office 2002 does support saving workbooks in XML format.

I didn’t address XML directly in the preceding chapter because lists are just one of the ways Excel handles XML. In this chapter, I show the different ways you can work with XML in Excel. Specifically, I show you how to:

• Save a workbook as XML

• Transform XML from a workbook into other forms of output

• Transform a non-Excel XML file into an XML spreadsheet

• Import XML to a list

• Export XML from a list

• Respond to XML import and export events

• Program with the XML map objects

This chapter contains reference information for the following objects and their related collections: XmlDataBinding, XmlMap, XmlNamespace, XmlSchema, and XPath.

Tip

Code used in this chapter and additional samples are available in ch15.xls.