wrinting measured data to excel

[2249kumar]

hello

i am new to labview. as my task is to send the measured data to excel sheet. can anyone post me simple example vi that links to excel sheet.

for example temperature readings w.r.t time

thanq

[NitzZ]

Hi kumar,

Did you try searching examples in the "find examples" link in labview? Check the report generation examples.

Warm Regards,

Nitz...

(kudos are welcome;) )

[GerdW]

Hi kumar,

-use "Write to Spreadsheet File" to save your data as CSV-file (which Excel can open easily).

-use "Write Measurement Data" to save a TDM(S)-file, an Excel plugin to load these comes with your LabVIEW installation

-use the ReportGeneratioToolkit to write "real" Excel files

-use the VIs commonly found here in the forum to access Excel via ActiveX

All of the mentioned possibilities have example VIs, which are accessible with the ExampleFinder of your LabVIEW installation...

[2249kumar]

thanq for your replies

i have tried with ' write to spread sheet file' ..i am able to get only one iteration in excel sheet ,but i want to get the values of all iterations ....i have attched VI ..

could you please help me out

[Dennis_Knutson]

Set the 'append to file' input to True. Select Help>Show Context Help and read the description of Write to Spreadsheet File. Have this help window open whenever you use LabVIEW.

p.s. And don't use Insert Into Array. You've already got the Build Array function. Use that for both elements.

[StefanR]

Hi kumar

what if you kepp your life simple? Just write a (interchangeable) TDMS file and use the (free) TDM Excel Add-In to read those files into Excel.

With TDMS files your data will stay consistent and can be accompanied by (the in future needed) descriptive information....

Greetings from winterly white Aachen

Stefan