Showing results for 
Search instead for 
Did you mean: 

Data acquisition format (excel data)


Tools: NIcRIO9037 with 5 Analog modules NI9215 (4channels each).

Objective of the code: 
    1. To acquire data from 20 channels. 
    2. To represent in a waveform and store it in TDMS format. 

Work done: I have written the program code which currently captures the signals from 20channels. I am able to see the waveform of the former too. 
The RT and FPGA program codes are attached to your reference. 

Support needed for: 
The expected result (in excel)is 20x500 - It must have 20 rows (corresponding to 20 channels) and 500 columns (corresponding the samples). 
But what I get in my excel sheet is 10500 rows and 20 columns (10500x20).
I have decimated the array as 20x500 in my RT block diagram. However, I wish my excel table to look as 20x500 form.

What parameter/corrections in the block diagram to be made so that I can view the excel in such a way. 

This result is necessary as this is the "format" that the matlab uses for data processing (which is already available in the existing system). 

Here's my excel sheet showing 20 columns and 10500 rows. 


TDMS file.png



20 channels - RT.png20 channels - FPGA.png

0 Kudos
Message 1 of 2



This is just the default way that TDMS files import to excel. Why? Because if you do it the other way you are limited to 16,384 samples since that is the max columns in Excel. Having samples as rows means the limit is now 1,048,576 which is easy to hit in a fast acquisition system.


If you must have it this way then you will need to use a different file format. What format does your matlab script use? You could use a csv file and then you can transpose the data if you wish. There are functions for this in LabVIEW called "Write Delimited Spreadsheet File".




James Mc
CLA and cRIO Fanatic
My writings on LabVIEW Development are at
Message 2 of 2