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 ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.