Datalogging direct into Excel

[CLJ]

Hello.

I am new to Labview but have already attended the basic 1 course.

I am having trouble with a data logging application.

The objective is as follow:

- Need to log data direct into an Excel file (A template excel file with an existing header).

- It would be very nice if data logging could be performed into an already open excel file.

- Log ONLY when triggered by operator (Person operating the system).

I have already solved the last issue using a "case structure".

How do I solve the first two issues?

Best regards

Christian

[Jorge_Amaral]

Hi,

See if the quick example that I've made you it's enough.

[CLJ]

Hi.

Thanks for the quick reply!

I am still having problems getting data into the excel file.

I have attached a .vi with your proposal incorporate - I have done two simulated signals (data) that I would like to log in the excel file. How do I connect these to the log circuit?

Of cause the simulated signal will later be replaced with real temperature, pressure and flow measurements.

Thanks alot.

Kind regards

Christian

[Jorge_Amaral]

Hello,

Each time you click on the "trigger" button you should see a new value written on excel. That's it's going like that on my laptop.

[juanni]

Can you save that it LV 8.2?  Thx.  Jonathan

[Jorge_Amaral]

IN labview 8.2

[amcolosk]

I would recommend that the report is closed using Dispose Report.vi, instead of Close File.vi since it causes errors, at least in version 8.2.  To print the measurement data to excel, you will need to convert the data into a 2d array. 

[juanni]

So, what would be the easiest way to get this to put a whole waveform (just the Y array) into a column in the report?  Just formatting the array into a spreadsheet string doesn't do the trick... it all shunts to a single cell in the spreadsheet.

[MikeS81]

Hi juanni,
you can split the waveform in the single components as time, dt and value. You can write time and dt to a single cell and value as range to a row of cells. You can use the ActiveX functions to write a range of data to excel, but think about the possible row size in excel.

Mike

Message Edited by MikeS81 on 05-15-2008 09:25 PM

[Jorge_Amaral]

Hello,

See the example