XML in Excel 2003 Standard Edition

[roygw]

I have been trying unsuccessfully to build an XML output stream for Excel 2003. I have used the xls file generated from the .Net webpage and saved it as an XML file to see how to construct my XML code. I have built the XML output stream but keep getting an error when trying to display the XML stream in Excel 2003. The error I get just says Workbook Settings and lists a .log file where error information is but for some reason that log file and the Content.MSO folder where it is supposed to be located does not exist in hidden or otherwise. I have been searching and have not been able to come up with any good information on how to build a valid XML stream for Excel that contains multiple worksheet examples. Is there a good book for this topic. Does anyone have a good way to debug these XML errors.

 

[toprngr]

If you already have a XML files, you need to use excel to open it as an XML file extension. After the XML dialog appears, choose the option that suit your needs best. You can always open it as an XML list. And if you want to bring in an xml file on your xls file, all you need to do is import the xml file to the xls file that you are currently using. All you have to do is click on the Data menu, point to XML and then click Import. Then the import XML dialog box will appear.