how to save data with difference ROW in Excel

[stevevantran]

Hi all,   I would like to save 10 time data of 10 run to difference ROW without changing the header. Attached is the file I am using now. Could someone help me to modify it? Thank you

Steve

[RTSLVU]

Wreite your header once and the data in a seperate part of the program loop

[smercurio_fc]

Are the channel names considered part of the header? Are those supposed to be written out each time as well? In other words, are looking for something like this:

Test Name,Operator,UUT
RF Test,AdvanceV,AAA123
Channel 1 Freq,Channel 1 Power,...
1.000,2.000,3.000
Channel 1 Freq,Channel 1 Power,...
1.000,2.000,3.000

Channel 1 Freq,Channel 1 Power,...
1.000,2.000,3.000

Channel 1 Freq,Channel 1 Power,...
1.000,2.000,3.000

which is picture provided by RTSLVU will give,

OR are you looking for something like this:

Test Name,Operator,UUT
RF Test,AdvanceV,AAA123
Channel 1 Freq,Channel 1 Power,...
1.000,2.000,3.000
1.000,2.000,3.000

1.000,2.000,3.000

1.000,2.000,3.000

If you want the latter, then the writing of the channel names should be outside the loop as well.

[stevevantran]

Thank you for helping me but it is always over write therefore the file record only the last test. More about my case is I am run test 3 times and save to same file I would like to save any test to difference ROW. My test date outside the While loop

[stevevantran]

How to create an EOL in to the spreadsheet file

[RavensFan]

In the VI, you posted, the very first Write to Spreadsheet file you have does not have the boolean input set to True so that it appends to the existing file.  Everytime your code hits that VI, the entire file will get overwritten.  Your other two Write to Spreadsheet files have the True constant wired.

I have no idea what you are talking about when you say "difference ROW in Excel".  Can you explain that?

For an end of line character, you can concatenate the constant located on the String palette to your string of data.  But if you are using the Write to Spreadsheet File VI's, that should be happening automatically. 

For more help, you will need to post the latest version of your VI.