Reporting toolkit and XLSX File

[jyang72211]

In my VI, I open an excel workbook in XLSX format, made some changes, and close/save the workbook in my program.  After that, when I tried to open the file manually, it says that the file is corrupted and needed to be fixed.  This problem doesn't happen when I do the same thing with XLS format.  Anybody knows what's going on?  Thanks!

[ben64]

Maybe a version compatibility issue. If your version of the RGT is older than the LV2010 version it does not support Excel 2010.

Ben64

[jyang72211]

What do you mean by RGT? 

[ben64]

RGT: Report Generation Toolkit

[jyang72211]

My RGT version is the one that comes with LabVIEW 2011 developer suite.

[REDS]

Hi,

According to this RGT with Office Compatibility KB, the RGT associated with LabVIEW 2011 should work with Office 2010 just fine, and therefore work with spreadsheet format .xlsx. That being said, let’s get into a little more detail what changes are you making to the spreadsheet file. Can you post your code to see what modifications you are making to the VI? Also a screenshot from Excel that shows the error would be helpful.

I tried this example with an already created .xlsx file and I tried to open it afterwards and I didn’t get any error.

[jyang72211]

I have attached the vi and the error.  Please help.  Thanks!

[REDS]

Hi,

Sorry for the late response. Can you include in your code Test Result Cluster and Create Dir if Non-Existent so that I can run your VI? Also, can you try to reproduce this on your local hard driver, as opposed to a network location?

[jyang72211]

Sorry for the late response.  The message completely fell off my radar.  i have attached the two vi requested.  When I ran the VI to repeat the bug, I did it locally, even though there are network path written down on the block digram.  Please help me to continue to look at this. 

[REDS]

Hi,

Sorry but I'm still missing "Build Path - Traditional_ogtk.vi" in order to see be able to run the code. Please make sure to include all subVIs that this VI might have.