Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Viewing an XML file in Excel

You can work with any well-formed Extensible Markup Language (XML) file in Microsoft Excel. (This means any file that is structurally correct according to the XML standard.) Microsoft has also defined the XML Spreadsheet (XMLSS) format designed specifically for Excel worksheets. This means you can:

  • Open any well-formed XML file.
  • Create Web queries to well-formed XML data sources.
  • Save an entire workbook in the XML Spreadsheet (XMLSS) format.

This article explains how an XML file is displayed when you open it in Excel

for more...

http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010346451033&CTT=6&Origin=EC010553071033

 

2 Comments



  • I think you should put less faith in marketing papers.



    "Save an entire workbook in the XML Spreadsheet (XMLSS) format. "



    This is simply not true. Where are your charts gone? Or may be charts are not of enough importance to be regarded part of workbooks, right?



    This also shows you haven't actually tested the link/technique you refer to, since whenever you do so you get prompted with a box saying "shapes, embedded objects and charts won't be exported".



    Belive me when I say it's of importance to use appropriate words. This can count in weeks or even months of reinventing the wheel and writing your own export only because Excel doesn't do what the marketing papers pretend.



  • Does the actual schema file exist? Do you know where to download the file? I have yet to find this file. I have used it, but where is it.



    James.ray@infinoen.com

Comments have been disabled for this content.