Write to spreadsheet file vi doesn't append

[sunflower2772]

Refer attached vi. I logged a bunch of data in excel .xls file, then restart the vi and log again in the same xls file, but i notice the new data doesn't append to the existing file but replaces all the old data 

In my write spreadsheet file vi, i already set true the append file setting.

How come this doesn't work, did i miss anything?

Advance thanks.

[Baji]

If u restarts the spreadsheet file vi,then it wont appends to the previous data.Find the VI to append the datas

[Dennis_Knutson]

The problem is not at all with the Write to Spreadsheet but with your VI. The very first thing you do is write the header with the function and there you do not set the append to true.

Never wire a constant to the while loop termination terminal. It's a very bad thing to use the abort button in most cases. Do it right with a front panel control.

[Maverick... · Accepted solution]

Hi,

You have made a mistake in the spreadsheet write outside the while loop. Append is not wired (it is FALSE) in the first write to spreadsheet VI. That is why it is overwriting the existing file. Please find the attached figure.