Excel Report

[Jarr]

Hello.  I have 3 VIs which make 3 excel reports. They work independently. I would like to know if I can write the 3 reports in only one Excel file (in separated sheets). I have try it but when I save the file, Labview overwrite the 3 sheets, not only the sheet where I generate the report.
Thank you.

[Joe_H]

Have a look at the excel board in the breakpoint area. There are some vi's in there that will help you. You have to set the active workbook and then save it.

[Scott Y]

The attached example may help.

Scott.

[Joe_H]

This will only work if you have the addon toolkit, the vi's in the other thread do not require the toolkit, they all use active X.

[Jarr]

Thanks for repply!!
I have the toolkit, but I want is: open VI1-save report in worksheet1-closeVI1, open VI2-save report in worksheet2-closeVI2, open VI3-save report in worksheet3-closeVI3.  I have seen the activeX VIs, but I can't find one which solve my problem.

[Cristobal]

Hello,

if you connect the Excel file path to template input parameter of New Report.vi, you will be able to obtain what you want.

I hope this helps.

crisR

[Jarr]

Thanks for reply!
It seems a good solution.