Creating XML file for Microsoft Excel

Discussion in 'XML' started by Charles Lavin, May 29, 2009.

  1. Hi --

    Can anyone direct me to a source of clear, concise information on how to
    build an XML file that can be opened by Excel as a spreadsheet? I need to
    build the file with the appropriate formatting requirements for the data,
    presentation aspects of the spreadsheet, and hopefully a way to make the
    data read-only.

    Playing around with XML import features in Excel and trying to make sense of
    an Excel spreadsheet saved as XML just gave me headaches ...

    I have a third-party legacy app that needs to be able to output many of its
    reports as XML files, almost all of them destined for Excel. The idea is for
    the user to just open these XML files in Excel and get a useable spreadsheet
    without spending a lot of time reformatting everything.

    Thanks
    CL
     
    Charles Lavin, May 29, 2009
    #1
    1. Advertising

  2. Charles Lavin wrote:
    > Can anyone direct me to a source of clear, concise information on how to
    > build an XML file that can be opened by Excel as a spreadsheet?


    Can Excel import .ods files these days? If so, the OpenDoc file formats
    are well-documented.

    For documentation on Microsoft's own XML formats, Microsoft would be the
    best place to look for documentation.
     
    Joe Kesselman, May 29, 2009
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Charles A. Lackman
    Replies:
    1
    Views:
    1,402
    smith
    Dec 8, 2004
  2. SpamProof
    Replies:
    0
    Views:
    602
    SpamProof
    Oct 21, 2003
  3. =?Utf-8?B?U3JpZGhhcg==?=

    using Microsoft Excel image for Export to Excel button

    =?Utf-8?B?U3JpZGhhcg==?=, Dec 9, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    3,134
    =?Utf-8?B?U3JpZGhhcg==?=
    Dec 9, 2005
  4. fniles
    Replies:
    0
    Views:
    282
    fniles
    Apr 26, 2009
  5. Kevin Howe
    Replies:
    6
    Views:
    235
    Kevin Howe
    Feb 6, 2005
Loading...

Share This Page