From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.


Showing results for 
Search instead for 
Did you mean: 

Storing array data (tab limited) in Excel file

Go to solution

Hi all,


I am using "Write to measurement file" for storing an array of measurements in different columns. The problem is it is storing all the data in one column under the title "untitled" and also filling in the time with year 1904. I want different column names with the various columns and also exact time of data storage. My excel file and program are attached here. Pls suggest how should i proceed. 


Download All
0 Kudos
Message 1 of 3
Accepted by topic author sr_murd

There is technically no such thing as a tab delimited Excel file.  Excel has their own proprietary format for files.

You can have a tab delimited text file that Excel can open or import.  Try using Write to Delimited Spreadsheet function in the File I/O palette instead of the Write to Measurement Express VI.


You have a race condition in your code where you are writing to terminals and reading from local variables of those terminals in the same loop.  In all likelihood, the read of the local variables will happen before the terminals get written to meaning you'll be reading stale data from the previous iteration.  You should get rid of those local variables and use wires!

Message 2 of 3

As well as what evil purple team fan said,  a search for. Time to will get you a nice vi to convert time to excel's epoch


-Vikings Fan

"Should be" isn't "Is" -Jay
Message 3 of 3