Excel 2000 and XML

E

Excel_confused

I am writing a class in PHP to take SQL data and create an XML file to be
opened by Excel. The file name will be like 'mydata.xls' but will be
formatted with XML. I t works nicely with Excel 2003, but not with Excel 2000.

In Excel 2000, it puts all the data into the 1st cell. The standard format
for the XML is from the Microsoft site recommendations, but the Excel 2000
issue was unexpected.

Does anyone have any possible work around for this? Are there any plug-in or
add-in modules that are required to get this to work?
 

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

Top