Microsoft Office Tutorials and References
In Depth Information
Note When you add a complex element (an element with subelements) to a worksheet,
Excel treats the element as a single list, not a series of lists, which occurs when you drag
simple elements to the worksheet individually.
After you’ve added the desired elements to your workbook, you can delete them as you would
delete any other workbook contents. You can also remove an element from a worksheet by
right-clicking the element in the XML Source task pane and clicking Remove Element on the
If you want to change how the XML data is inserted into your worksheet, click the Options
button in the XML Source task pane. You can use the options to preview your data in the task
pane, hide help messages in the task pane, and let Excel know you have already added data
labels so that it won’t ask every time you insert a field. You can also change how Excel imports
XML data by opening the Data menu, pointing to XML, and clicking XML Map Properties.
You can use the controls in the XML Map Properties dialog box, shown in Figure 26-6, to
change whether Excel resizes the columns to reflect the size of the data, preserves number
formatting, and validates XML data against the associated schema before importing or export
ing that data.
Figure 26-6. The XML Map Properties dialog box gives you more tools to control your
Importing XML Data Manually
Once you have assigned the schema elements to worksheet cells, you can import data into the
worksheet from the XML data file that matches the structure of the schema.
To import data into an existing XML schema, follow these steps:
1 Click Data, XML, Import.
In the Import XML dialog box, navigate to the folder that contains the XML data file,
click it, and click Import.