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.
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:
Code used in this chapter and additional samples are available in ch15.xls.