I'm haveing a problem saving my test results to excel using the report generation toolkit.

[harene.pitter@tripointglobal.com]

The vi appends the data to a excel worksheet but it won't save it to a designated file path. And of course errors occur. I've narrowed the problem to be somewhere in the "Generate Report get data to memory.vi". And though I specify "excel" it try to force my report to a standard. HELP!!!

[JRA]

Have you tried the sample VI "Sample Report (Excel)" yet? You may want to try running this and see if it exhibits the same behavior. It should be located in the LabVIEW>>examples>>office folder inside the ExcelExamples.llb.

[harene.pitter@tripointglobal.com]

Yes I did try running that VI and I encountered an error code of -2147467262. It is telling me that no such interface is supprted in Excel Import Module.vi>Append Text to Report.vi>Excel easy table to Report.vi>Sample Report (excel).vi.

My Windows GetComm Error is:the hex value of this code is x4002: x4000-serial port VI error;x0001:receiving overflowed or character was received after end-of-file character.....

[km76107]

Hi

Have you found a solution to your problem of saving excel spreadsheet data using Report Generation toolkit yet? If so, could you please post it here? I am trying to do the same thing and can't figure out how to save the excel data.

Thanks in advance.

[Joe_Guo]

After the "Save Report to File" vi, dispose the file reference by using "Dispose Report" VI and wire "True" to "Save Changes?" input.

-Joe

[km76107]

Thank you so much Joe. I had to make some modifications to what you said. But IT WORKED!!!

Thanks again.