• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. XML and Office > XML and Excel 2003

XML and Excel 2003

XML Maps

In Excel, much of the processing and manipulation of XML data is managed through the use of a new object: the XML map. Maps essentially are representations of XML schema. The advantages of XML maps are that they are contained in a collection; they can individually be swapped in and out; and they have several properties and a few methods with which to manipulate data.

The Add method is used to add a map to the XmlMaps collection. The collection belongs to the Workbook object. A map can be culled either from a schema file or directly from an XML file. In the latter case, Excel will infer a schema from the data. In Listing 9.18, the explore_maps routine shows how two maps are added. The first is from a schema, and the second is directly from an XML file.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint