Write from labview to excel test results

[RBM89]

Hey

I need some help to get my results from pressure transmitter to excel in 2 rows. 

The program works like when you get into case 9 like in picture and it will stay there in 15 min. I want it to log the pressure from my DAQ from 0-15min into a excel sheet. 

I have tryed so many things now and I cant find a good solution 😞 

I want to choose were it will be saved before I get into case 9 in my frontpanel. 

Like          Time          Pressure

                 11.15.30    2000 Bar

                 11.15.31    2000 Bar

                 11.15.32    2000 Bar

                 11.15.33    2000 Bar

                 11.15.34    2000 Bar

                 11.15.35    2000 Bar

Just ask if you need to know more about my program! 🙂 This is my first program I have made in labview

Best regards Hermansen

[SteveD123]

Before giving any advice, I'd like to know whether you solved your transducer noise problem http://forums.ni.com/t5/LabVIEW/Pressure-Transducer-4-20mA-noise/m-p/2825160#M826539 .

Whether you find advice helpful or not, it's polite to follow-up when people have taken the trouble to make suggestions.

[robertpf]

Hi RBM89,

For general information about logging I recommend this link for a start:

Adding Data Logging

http://www.ni.com/academic/students/learn-daq/data-logging/

Using the Write To Measurement File.vi it is possible to promt the user for the file storage location etc.

Below are a few examples of implementations with data logging, hopefully you will find some interesting code there:

Logging Data apart from Zero

https://decibel.ni.com/content/docs/DOC-9931

DAQmx: Continuous Acquisition and Updating while Logging Averages to File

https://decibel.ni.com/content/docs/DOC-29760

Continuously Log Data to a TDMS File

https://decibel.ni.com/content/docs/DOC-11298

Please also note that logging data is a time consuming operation that might slow down the execution rate of the loop. For high performance I would therefore recommend adding the data to be logged to a queue, and writing the queued data to file in a separate loop. 

This document will give you a introduction to queues in LabVIEW:

Communicating between Parallel Loops

http://www.viewpointusa.com/resource/view/newsletters/communicating-between-parallel-loops/

Best regards,