12-05-2014 07:10 AM
Hello Everyone,
I made a Pressure calibrator which continously sends data to pc via UART at an interval selected by user, now we are displaying it on hyper terminal, however I want to design a Labview program which will take this data and log it in excel. I was able to send numeric character in labview group them together and display on a Guage, however the Data format now for eg. is '+150.10mmWC ' followed by CR and NL., if the pressure is 150.10 mm of water column. Can you point me some sources where I will get info to log these incoming strings as it is in excel file along with their time stamp so I can read up on them.
Thank You.
12-05-2014 07:22 AM
Look in the File IO palette. You will find functions in there for opening and closing a file and for writing. You will want the Write Text File. Also study the String palette. The Format Into String may be of particular interest to you here.
What I'm recommending here is that you don't write a xls file, but a CSV (comma seperated values). It is a text file format that uses a comma to seperate channels. Excel can open up a CSV file with not problem.