Create an XML Data Map : XML « Collaboration « Microsoft Office Excel 2007 Tutorial






Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer tab. Then click the Source button.
Click the Developer tab. Then click the Source button.
Click the Map name list arrow, and then click the XML schema.
Click the Map name list arrow, and then click the XML schema.
Drag the named elements from the XML Source task pane to the corresponding cells.
Drag the named elements from the XML Source task pane to the corresponding cells.
Click the Header Options button, and then click the header option.
Click the Header Options button, and then click the header option.








13.9.XML
13.9.1.Save XML DataSave XML Data
13.9.2.Open an XML data fileOpen an XML data file
13.9.3.Import XML DataImport XML Data
13.9.4.Export XML DataExport XML Data
13.9.5.Create an XML Data MapCreate an XML Data Map
13.9.6.Change XML Data Map PropertiesChange XML Data Map Properties
13.9.7.Attach a SchemaAttach a Schema