save variant waveform from hardware to spreadsheet file

[scientist]

I am reading a waveform from a teststand (external hardware) into labview as a variant data type. I need to save the data into spreadsheet. Can anyone help? Also, do I specify the path as excel (.xls) or text (.txt) or what?

Thank you very much.

[Herbert Engels]

The easiest way to save spreadsheet files is the Express VI "Write LabVIEW Measurement File". "Data from variant" converts the variant to a waveform or an array of waveforms you can wire to the Express VI. Several settings in the Express VI configuration page(how many headers, how many time columns) help you to format the file just like you need it in Excel. Default file extension is LVM, but can be changed to anything. Regardless of the file extension, the result file will be tab- or comma-separated to fit into Excel.

[KileenC]

Hi,

You can also take a look at the Export Waveforms to Spreadsheet File.vi shipping example available with LabVIEW. It can be found under Help >> Find Examples >> Fundamentals >> Waveforms. You will need to first use the Variant to Data.vi as shown in the previous post, but once the variant has been converted, then you can wire that Waveform Array into the Write waveform data to a file.vi.

Hope this helps! Good luck.

Kileen C.
Applications Engineer
National Instruments