• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 29. Working with External Data > Working with XML Files

Working with XML Files

One of the most important new features in Excel 2003 is its capability to open, import, and export Extensible Markup Language (XML) data in any structure. The previous version of Excel supported XML only to the extent of being able to save and open spreadsheets in a particular schema, called XML Spreadsheet. Existing data in XML files that did not use this schema were still locked out. This is no longer the case.


Opening or Importing an XML List

To open a list that has been saved in XML, simply choose File, Open. In the Open dialog box, you can set the Files Of Type line to either XML Files or All Microsoft Excel Files (the latter is Excel's default setting). When you select the file you want and click Open, Excel displays the Open XML dialog box, shown in Figure 29-6. Choosing the first option, As An XML List, creates a list in which each element of the XML structure is a column (see Figure 29-7).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint