export measure data from digital mulimeter to excel

[ST83]

Hello LabVIEW users,

I have a problem with expoting measure data from an digital multimeter (Agilent 34401A) to excel and until now I have not found a tailored solution for the problem. I do not want ot use the included function (waveform to spreadsheet file.vi), because in my opinion the process of loading and formatting the data in excel lasts to long.

For help or hints regarding to that problem I would be very grateful.

Bye

ST83

[Albert.Geven]

Hi

If you use the built in function with a "," as separator and gives the file a .csv extension excel reads them automatically!

A simple toolkit that writes to excel via activeX is also available but depending on the excel version you need a recompile and rearranging some properties.
(due to everchanging Microsoft)

[Wayne.C]

All the Engineers around here demand Excel files so I use the "Report Generation Toolkit for Microsoft Office".  Its included with some the packages.  I create an Excel Template ( *.xlt ) that has all the report formating done.  Cell widths, fonts, etc.  I then use the reporting tools to open the template, slap in the data and save the file.  Gives you the option to have multiple worksheets in a workbook.  Usefull if you need to document multiple passes of a test in the same file.  You can even print and email the file. 

I have in the past written tab delimited data using the array to spreadsheet vi and just saved the file as a .xls file.  Data is in row and colums but you still need to format sizing etc.