Dispose Report.vi cannot release excel

[IO HUI]

HI.

This is my first time to use the sub vi to generate excel file.

I have used New report.vi and Dispose report.vi from the report generation kit but I can see from the Window Tast Manager, the excel .exe is stil running after the Dispose report.vi.As a result of that, I cannot see the excel file when my LabVIEW programme is running.

Actually is it normal for that ?

Thanks in advance.

IO

[Brian_K.]

Hi IO,

I tested my report generation toolkit, and for me it closed excel entirely.  To test it simply had a New Report and Dispose Report with excel selected as the type.  I saw excel open up and then close back down.  Then I checked the Task Manager and sure enough Excel was not there.  Have you cut you program down to only those 2 VIs.  Maybe there is something else preventing Excel from closing.

[IO HUI]

Dear Brian K,

Thanks for your reply.

Actually I have used the VIs in the toolkit to generate the excel file.

My flow is : generate new excel file>make a new name to the worksheet to A>add a title to the data in sheet A>put the data in the worksheet A>save the file>select the other worksheet>name the worksheet to B>put some data to it>save the file>create graph >put data to graph>change the graph proporties>save the file>maxmize the excel window>dispose report.

I have setted the whole programme to be continously running.

What I suppposed is the excel file will be released after the first looping,then it will active again when the flow is reach to the VI to create excel file but in the real case, it doesn't behave like that.

So I don't know whether I have got anything wrong with my flow or it's normal for that in LabVIEW.

Thanks in advance,

Io Hui  

[Wayne.C]

Hui,

New Report.vi has a terminal labeled Display Alerts, it defaults to False.  Set it to True so that any warnings generated by Excel will be displayed when your vi runs.

[IO HUI]

Hi.

Thanks for your reply.

I have changed the alert from false to true but I cannot see anything happen.

Actually is there anything that would supposed to be pop up in normal case when I use the alert?

Thanks.

Io Hui

[Wayne.C]

Normally I would not expect much with that turned on.  Post your vi that creates the report. 

[IO HUI]

Hi.

Thanks for your reply again.

Here is my vi's picture.I 've extracted my main flow of the programme because my programme is too large.

Thanks.

Io

[IO HUI]

Sorry..I am tring to add the attachment..

[Wayne.C]

I didn't have time to redraw your diagram but I think I know what is wrong.  It appears that you have used the create report.vi twice in your vi and have only used the dispose report.vi once.  That means that you opened up two copies of excel and only closed one.

Suggest you clean up your code a bit and remove the extra create report.vi in the inner while loop and all the extra save report to file.vi and see what happens.