04-07-2012 10:19 AM
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
Solved! Go to Solution.
04-08-2012 06:43 PM
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.
04-09-2012 06:17 PM
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
04-10-2012 01:26 PM
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,
04-10-2012 06:34 PM
@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.