LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Organizing a multiplexer acquired data in a spreadsheet file of a column major order

Solved!
Go to solution

I am a beginner user of Labview, but I managed to make VI incrementing a running index from 0 to 15 in order to interface with a multiplexer, while providing a predetermined time delay between each cycle of the sixteen iterations. I have just emulated this case study before its practical implementation by constructing a VI saving the analog data acquired from a two analog input ports at each value of the running index in a txt file (File: Multiplexer_Output_Data_Test.pdf). The challenge is how to alternatively store the data in a spreadsheet excel file in which every row has a thirty three cells, or in other words, the first cell has the time stamp, while the next sixteen cells contain the analog data of the first port spanning all the sixteen values of the running index, and the same approach applies for the last sixteen cells associated with the second analog input port. The process repeats itself after the predetermined time delay in the successive rows. In the attached VI, I would like to replace the last frame of saving into text file with my desired form in excel sheet.

 

Any help would be highly appreciated

0 Kudos
Message 1 of 5
(3,117 Views)

If you can, save the data in a *.csv file because that type of file is a text file that can be read by Excel.

 

Otherwise, read the LabVIEW examples on how to write to an Excel file using ActiveX.

0 Kudos
Message 2 of 5
(3,093 Views)

Your help is really appreciated and enriched my knowledge, however, it didn't satisfy my needs, since the main problem I face is how to save a dynamic data not a pre-acquired one. My challenge is how to dynamically save the data in a different cell location each acquisition process.

 

Thanks again for help

0 Kudos
Message 3 of 5
(3,072 Views)
Solution
Accepted by topic author Diaa Abidou

Hi Diaa,

 

I found this example and I think this applies to your needs. You can find more information about Dynamic Data Exchange here.

 

Regards,

steve.bm
AE | NI
0 Kudos
Message 4 of 5
(3,052 Views)

 


@Steve.bm wrote:

Hi Diaa,

 

I found this example and I think this applies to your needs. You can find more information about Dynamic Data Exchange here.

 

Regards,


This is exactly what I am looking for all the past week.

 

Your help was extremely appreciated and to the point.



 

0 Kudos
Message 5 of 5
(3,042 Views)