How do you remove header, time and date from 'export waveforms to spreadsheet file' subvi ?

[nfraiman]

I am using "Export Waveforms To Spreadsheet File.vi" in order to export data collected by labview into a file.

The default format however is as follows:

waveform    [0]
t0    11/13/2009  14:54:34
delta t    0.001000

time    Y[0]
11/13/2009  14:54:34    -2.441406E-3
11/13/2009  14:54:34    -2.441406E-3
11/13/2009  14:54:34    0.000000E+0

Yet I am interested only in the actual data, without header or time and date stamp, e.g.:

-2.441406E-3

-2.441406E-3

0.000000E+0

Could someone please help me with tailoring this subvi to my needs?

[Dennis_Knutson]

Then why don't you just use the Write To Spreadsheet File function? Use the Get Waveform Components function to get the Y array.

However, if you do not save some of the information (especially dt), the data is not as useful as it could be.

[nfraiman]

>Then why don't you just use the Write To Spreadsheet File function? Use the Get Waveform Components function to get the Y array.

>

>However, if you do not save some of the information (especially dt), the data is not as useful as it could be.

I do not need dt, because I already know what interval between data points is.

Could you elaborate please on this method, especially the Get Waveform Components function? I can't seem to find it.

[Dennis_Knutson]

Its on the Waveform palette surprisingly enough. You can also use the 'Search' button on the top right of the functions palette.

You may know the dt now but if someone were to take the files and do some analysis, they would have no idea. It's also a possibility that you could forget.

[nfraiman]

We have a function that expresses dt independently, and we're only interested in the raw data.

How do you get the Write To Spreadsheet File function to display the information in columns instead of rows?

[Dennis_Knutson · Accepted solution]

Set transpose to true.

[nfraiman]

Yes, I discovered that one but it wasn't doing it when I was running the file.

However, I chose to make the setting default and that got transpose to stay in the correct setting.

Thank you dearly, o Knight of NI.  Now excuse me, I shall go chop down the largest tree in the forest with..... a herring !

[Dennis_Knutson]

Please don't say that you changed the Write to Spreadsheet function instead of wiring a True constant in the main VI. If you did - UNDO that. Modifying the VIs that ship with LabVIEW in such a manner is a very unwise thing to do.

[nfraiman]

>Please don't say that you changed the Write to Spreadsheet function instead of wiring a True constant in the main VI. If you did - UNDO that. Modifying the >VIs that ship with LabVIEW in such a manner is a very unwise thing to do.

Ugh.. I'll change it back if i succeed in wiring a true constant in the main VI, which I have no clue how to do, but I'll give it a shot if you could explain how exactly this is done.

I think it should be noted that despite my traditional programming experience, I am a complete LabVIEW novice.

[Dennis_Knutson]

Right click on the input and select 'Create Constant'. Click on the constant to change the value (i.e. From False to True).