Tektronix TDS 784A - Exporting waveform and measurement from Labview into Excel file

[ingtony111]

Hi,

I have just started using Labview and I am trying to export data from the Tektronix TDS 784A into an excel file.  I am using labview V2009 and I have downloaded all the required drivers for the 784A.  I am able to to aquire waveforms and perform measurements (period, frequency, etc) from the 784A into Labview using the apporirate VIs.  However, I would like to then export the waveform and measurement from Labview into an excel file on my PC and am having touble doing this.  I am using a VI named TKTDS 7XX Read waveform to file.vi.  This exports data in .wav format.  Anyone help me to this in .csv format?  Any help would be appreciated.  Thanks.

-Tony

[ingtony111]

Does anyone have any advice for this?  Any suggestions are appreciated.  Thanks.

[smercurio_fc]

Which drivers did you download? The .wav file is probably some sort of binary file. If the Read Waveform VI returns the values then you can use the Write to Spreadsheet File VI to write a delimited text file. By default that VI uses a tab as the delimiter between columns. If you wire in a comma then you'll have the traditional CSV format.

[ingtony111]

I am using the drivers avilable on NI website for the Tektronix 784A oscilloscope.  I am assuming I will have to alter the Read Waveform.VI file in order to convert to spreadsheet?

[Dennis_Knutson]

That assumption is not at all correct. You can do it simply enough in your main VI. If you are using the TKTDS 7XX Read Waveform to Voltage Array.vi, you can just unbundle the waveform returned, wire the appropriate outputs to a Build Waveform function and then wire that to an Export Waveforms to Spreadsheet File function.

If you haven't already done so, I would suggest starting with the basic LabVIEW tutorial.

[StefanR]

Hi Tony,

you might find this thread useful:

http://forums.ni.com/t5/LabVIEW/Excel-file-for-continuous-data-of-DAQ/m-p/1581188#M578338

with these links in it:

Moving Data From LabVIEW Into Excel

http://zone.ni.com/devzone/cda/pub/p/id/1339

Editing TDM(S) files with the TDM Excel Add-In

http://zone.ni.com/devzone/cda/tut/p/id/12561

TDM Excel Add-In Tool for Microsoft Excel User Guide
http://zone.ni.com/devzone/cda/tut/p/id/4906

LabVIEW 2009 Features and Changes
http://zone.ni.com/reference/en-XX/help/371361F-01/lvupgrade/labview_features/

Moving Beyond Microsoft Excel for Measurement Data Analysis and Reporting
http://zone.ni.com/devzone/cda/tut/p/id/11430