Instrument Control (GPIB, Serial, VISA, IVI)

cancel
Showing results for 
Search instead for 
Did you mean: 

Writing numeric data to spreadsheet

I have some data that I have read in through the serial port. I have wrote a vi to format the data and display it. Now I would like to save the numeric data to a spread sheet. I believe IM reading in the data at 400 hz and it was suggested to me to store it to memory first and then save it later. What's the best way to write the code to save this data to a spreadsheet. I have attached my vi, the data I want to record is the range data and signal strength. Eventually I would like to put a strip chart in as well.
0 Kudos
Message 1 of 4
(3,448 Views)
That depends on how you want to save your data.
The easiest way is to use Write to Spreadsheet File from the File I/O palette.
If you want to put text labels in you can add a header later or you can convert the VI to handle strings as well.
You will need to use Build Array and a shift register to store the data until you save it.
Also, I suggest you clean up your VI a bit.

___________________
Try to take over the world!
0 Kudos
Message 2 of 4
(3,440 Views)

I am new to labview. I am going to use a File Dialog and also a write to spreadsheet in order to save my file.  How would i hook it up correctly?

 

Jack

0 Kudos
Message 3 of 4
(3,079 Views)
0 Kudos
Message 4 of 4
(3,066 Views)