Creating XML file for Excel


Charles Lavin

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.


Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question