Creating XML file for Microsoft Excel

C

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.

Thanks
CL
 
J

Joe Kesselman

Charles said:
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.
 

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

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top