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?
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?