About XML maps

Microsoft Office Excel 2003

About XML maps

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

When you add an XML schema to your workbook, an object called an XML map is created. XML maps are used to create mapped ranges, and manage the relationship between mapped ranges and elements in the XML schema. In addition, these maps are used to relate the contents of a mapped range to elements in the schema when you import or export XML data.

A workbook can contain many XML maps. Each XML map is an independent entity, even if multiple maps refer to the same schema.

An XML map must contain one root element. If you add a schema that defines more than one root element, then you will be prompted to choose the root element to use for the new XML map.