Microsoft Office Tutorials and References
In Depth Information
Figure 5-5 displays the XML Structure task pane available in Excel. When
you first display the task pane, Excel asks whether you want to find a structured
(XML) document, create a new one, or add structure to this document (which
means adding a schema to your current data file). When you click Create New
in the XML Structure task pane, Excel switches to XML design mode and
prompts you to select a schema.
Figure 5-5 The XML Structure task pane in Excel enables you to map
XML elements to your worksheet and customize the design.
Importing and Exporting XML Data
Importing an XML file is as simple as clicking the Import button on the XML
toolbar. The XML toolbar is a new addition in Excel 2003, providing quick and
easy access to import, export, and refresh actions.