Displaying my results in excel format...

[keeper]

I want to have a program that goes like this.I have data feeding in from a external source.
Eg:
1)i want to display this data
2)save and print this data with current time and date.

[Bharathi]

Hi,

The external data can be displayed along with the acquired date/time by using build waveform function and the waveform chart.
For storing the data with the timestamp, the data is formatted into string and this string is concatenated with the date/time string and written to the file. Please find the VI attached that displays and stores the data (random number) into the excel file.
Hope this helps!

Regards,
Bharathi

[keeper]

i am quite new to this labview....and yr program is not a VI program is something else

[Bharathi]

Hi,

Sorry the previous attachment was not opening. I have attached the another VI.
The program actually generates random number ( using random number under numeric function palette) inside the for loop. The loop executes for the loop count times that can be configured by the user. Now each time the loop is executed one random number between 0 to 1 is generated. This random number is then converted to an 1-D array and again a waveform is built using the timestamp generated for each random number. The resulting waveform is plotted in the waveform chart. The array is again formatted in to spreadsheet string using Array to Spreadsheet string function for storing it in the excel file. This timestamp generated using Get Date/Time is seconds function is formatted into getting date string and time string. Now the data string and the date & time string are concatenated and written into the file. The file is opened before all this operation and closed after the loop execution is over. Therefore, each random number, the date and time at which it is generated are stored in the excel file. Please find the attached zip file for the VI.

Regards,
Bharathi.

[keeper]

Hi me newbie,
What kind of file is it saving as?What is the iterations for?Can i make it to append data to the last file instead of keeping asking me for the file name?

[Bharathi]

The file that is saved is an excel file. The iterations are for generating random number for loop number of times. Since you explained that continuous is being received, I just tried to explain it with the use of random number generation using for loop structure. The file can be appended by wiring '1' to the pos mode terminal of the write file function. By doing this we configure the position from where the read or write operation is executed. You can wire a constant file path from where the excel file is either replaced or appended in the Open/Create/Replace File function. I have also attached the updated vi for more clarity.