I am using LabVIEW 8.5 with Microsoft Office 2007 on Windows XP on one computer and LabVIEW 8.6 with Microsoft Office 2003, WIndows Vista on another computer.
I wrote a program which writes some data to an excel sheet. The output of the program is as expected in LabVIEW 8.6 + Office 2003 + Windows Vista.
However, when I run the same program on LabVIEW 8.5 + Office 2007 + Windows XP, after the program execution is complete, when I try to open the excel file in Office 2007, it displayes an error message that "Unreadable content.". Is it an issue with compatibility of LabVIEW 8.5 with Microsoft Office 2007?
Thank you very much for your reply. Please find the attached program, which I have to run on the specified two combinations. In Excel 2003, I get the expected output, but not in Excel 2007. Can you please help me what modifications should I make to this program in order to get the same output.
In excel 2007, when I try to open the sheet after executing the program, an error message "Unreadable Content" is displayed.
Vilas V Jangale
Ravens Fan brings up what I noticed at first as well - the polymorphic nature of the Write to Spreadsheet File means you can only wire in 2D or 1D data.
It shouldn't matter what version of Excel you're using for that VI. On the other hand, if you're using the Report Generation Toolkit, it very much matters what version of Office and LabVIEW you have. Please check out this KB: Report Generation Toolkit Compatibility with Microsoft Office and LabVIEW.
Try removing writing both 1D and 2D data and see what happens.
It remains true however, that Excel 2007 complains about reading the text formatted files. That is a "feature" of Excel 2007 for files that are not in Excel native format. You can still import the data into Excel, but clicking on the text file (even if it is named with an extension of .xls or .xlsx) and expecting Excel 2007 to open it without complaint will not happen. You can write files in native Excel format from LabVIEW using ActiveX, but then you face the situation that the ActiveX interface changes with each new release of Excel. Thank you Microsoft.