Hey Ido,
Looking at Microsoft's documentation, it looks like there's a function called OpenXML which has a parameter for stylesheet. When opening an XML file, a stylesheet does need to be configured in order to present the data in a recognizable format. This lack of stylesheet specification would account for the behavior you are seeing. The Excel-Report instrument driver in CVI is a wrapper around Excel's ActiveX Automation API. Not all functionality of Excel is supported within the instrument driver. For full functionality, you need to use the Excel Object Library (as is presented underneath the Excel Report instrument driver in the Library Tree). Looking through the 9.0 Object Library (corresponding to Microsoft Excel 2000), I did not see the OpenXML function present (though it could be somewhere). When I loaded the Excel Object Library for 11.0 (Excel 2003), I found the function OpenXML with the parameter for stylesheet. It would seem that Excel 2000 did not contain the OpenXML function, but you would have to check with Microsoft.
For documentation on how to use the OpenXML function, consult MSDN or the web.
An additional option for doing this would be to use the DOMDocument object library, as alluded to by this Microsoft KB:
http://support.microsoft.com/kb/307230. Since it would seem there might be an issue with the OpenXML function (as documented in the KB), I would think the DOMDocument conversion into html prior to opening would be the best option.
As to how you would use any of these functions or methods, I would recommend looking at Microsoft forums and external resources (as they are not supported by NI).
Hope this helps!
Thanks,
Andy McRorie
NI R&D
