Continue writing in an excel worksheet

[vaib]

Hello I am engineering co-op who is very very new to LABVIEW 7.1. I want to build a vi which takes data from pressuer sensors through a DAQ SCXI-1121 to an excel work sheet and continues writing without overwriting till i stop the vi. I have made a small attempt. Please suggest appropriate modifications. Thanks a ton in advance...

[Dennis_Knutson]

There is a Boolean input to Write to Spreadsheet called 'append to file'. You have nothing wired there and the default is false so you get a new file each time.

Since you are using the Express VIs for everything, why did you not use the Express VI called Write to Measurement File? If you use that, then you would not be trhowing away all of the timestamp data like you are now.

[vaib]

Thanks a lot. It is running right now without erasing anythiong. But i am not able to see the time of the observations though, i.e , is there anything else I should do to get that. it is only giving me the pressure values. I tried by the append to file solution... Thanks again

[Dennis_Knutson]

As I said, you are throwing away the timestamps. The 'Convert From Dynamic Data' does that when you choose to convert to DBL array. It only converts the Y data. As I also said, you can simply use the Write To Measurement File. If you convert to a 1D array of waveform data, you can use the Export Waveforms to Spreadsheet File. To use the normal Write to Spreadsheet File, you would have to convert to a waveform array, use the Get Waveform Components to get t0 and dt, then format that into a 1D array of strings, convert the Y array data to string data, append the arrays, and then use Write to Spreadsheet in string mode. Depends on how much coding you want to do, how much you know, and how much control over the file output you want.