Working with XML Files
Excel can open, import, and export XML data in any structure. To open a list that has been saved in XML, click the Microsoft Office Button, and click Open—just as you would to open an ordinary Excel workbook. With the Open dialog box set to display all Excel files, your XML files will be included. But if you’re having trouble finding the file you want (because of all the other Excel files in the same folder), select XML Files in the list beside the File Name box.
When you open your file, Excel presents the Open XML dialog box, shown in Figure 23-9.
Figure 23-9. When you open an XML data file, Excel presents this dialog box. ...
Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
