請問該如何使用Dispose Report.vi只存excel檔，但不關閉呢?

[jerry0521]

大家好，因為我需要重複寫入同一個excel檔，儲存後不要關檔案，所以我利用New report的template設定為該excel檔，Dispose Report.vi去存檔，但是在Dispose Report.vi的Save report設定為true，close report設定為false，這樣做似乎是不會存檔，除非將close report設為true，請問有什麼方法可以修改的嗎？謝謝!!

[muks]

Please try posting in english here

Translation

"because I need to repeat the same to write a excel file, save the file instead of closing later, so I used the New report of the template to set the excel file, Dispose Report.vi to the archive, but in the Dispose Report.vi the Save report settings is true, close report is set to false, this seems to be no archive, unless close report set to true, is there any way to modify do? Thank you!! "

[Yarmouth]

Why do you use the Dispose Report.vi?You can write data continously until it is done, and then use the Dispose Report.vi to save and close the EXCEL file.

[Billingsley]

繁體中文請到 ni.com/taiwan/forum

[jerry0521]

Hi, All, Thanks for your replies, I forgot to select community, sorry.

 I saw the Dispose Report.vi->Excel_Quit.vi block diagram and found if just "save change" sets to ture but "Close Report" sets to false, it can't save file(see close report(True).png and close report(False).png). I modified Excel_Qui.vi(modified.png) and it can save Excel file now.