Chapter 3. Work 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.

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

• Create templates for XML

• Respond to XML import and export events

• Program with the XML Map objects

• Bind lists and ranges to XML data sources