Saving the table content into one excel sheet

[Marc.Schlachter]

Hello,

I have got following problem:

I'm measuring data with a DAQ card. I'm interested in the min and max value of the measured data. Therefore I'm using the Amplitude and Level measurent function. Its no problem to display the results in the graphical interface. What causes me trouble is to save the content of the displayed table into some kind of file. Anybody know a solution?

Thanks!

[smercurio_fc]

There are many file VIs and functions:

• Write to Spreadsheet File (creates a text file with delimited columns) 
• Write Text File (writes out straight text)
• Write Binary File
• Write To Measurement File
• TDMS Write
• Write to XML File
• ...

In your title you said "excel" but in your message body you said "some kind of file". Please be more descriptive of what you're looking for.

[Marc.Schlachter]

The problem is that I use the descriped min/max function. If I write it to a text file I get a lot of additional information every second.

Following example shows what is written to the measurement file:

Channels 6      
Samples 1 1 1 1 1 1 
Date 2010/03/05 2010/03/05 2010/03/05 2010/03/05 2010/03/05 2010/03/05 
Time 14:26:48.9938435554504394532 14:26:48.9938435554504394532 14:26:48.9938435554504394532 14:26:48.9938435554504394532 14:26:48.9938435554504394532 14:26:48.9938435554504394532 
Y_Unit_Label Volts Volts Ampere Ampere Ampere Volts 
X_Dimension Time Time Time Time Time Time 
X0 0.0000000000000000E+0 0.0000000000000000E+0 0.0000000000000000E+0 0.0000000000000000E+0 0.0000000000000000E+0 0.0000000000000000E+0 
Delta_X 0.001000 0.001000 0.001000 0.001000 0.001000 0.001000 
***End_of_Header***       
X_Value U_1 (Positive Peak) U_2 (Positive Peak) I_3(Positive Peak) I_1 (Positive Peak) I_2 (Positive Peak) U_3(Positive Peak) Comment
0.000000 3.461911 3.189588 0.115779 2.103480 0.739258 1.206654

This kind of information is not displayed if I visualize it in a table. The table only shows me the time and the corresponding min/max values. These values are updated every second.

I tried to write it to a spreadsheet,  this approach was also not successful since a new spreadsheet was opened/generated every second respectively every time a new min/max value was aquired.

I would like to safe the data fro, the table to a file without the additionál information showed above in the example.

Thanks!

[Guruthilak]

use streaming to dis option...

The reason why you were creating multiple files is becasue "append to file? (new file:F)" option is set to False by default and hence new file got created.

[srikrishnaNF]

Hi Marc,

  I think you are trying with  write to measurement file express VI to log the data.So while configuring the express VI,you need to set the options as NO headers and No time column.

Thanks and regards,

srikrishnaNF

[Marc.Schlachter]

Hi srikrishnaNF,

Thanks, that was a quick solution.