O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required