Seperate data in Exel

[Mully]

Hello all!!

Im new to labveiw and have a vi writing data taken from a GPIB connected power analyzer.

When I press a button on the front panel the vi writes data Volts ,amps,watts ,time.

I want to seperate each set of data taken from the next set..... when the button is pressed each time.

Any thoughts??

Thanks

Mully

[Michael_Munroe]

How do you want it separated?  On a new line, as a new block, on separate worksheet, or in a separate file?  If you are writing each set as a tab delimited row to a spreadsheet file, then just append a CR/LF (or \r\n) to each data set to make a new row.  If you want separate blocks, you can double space the row between blocks (\r\n\r\n).  Separate worksheets requires ActiveX control of Excel.  Separate files can be created by appending an index to the filename (i.e. _001).

[Mully]

Thanks Michael

I cant figure out how to add anything to the Excel file created except the numerical data input to the ....write Labview measurement file .vi.

I would like to append the same file with a list of data sets seperated by text or spaces between each set of data taken.

Example:

Volts Amps Watts

120    3.4    1200

122    3.6    1208

New data

121   3.61    1203

122   3.4      1201

[Philip_Courtois]

Hi Mully,

Since you don't specify how many measurements (rows) you expect for each data set, I have created a small example that just writes one column of data values (three random values) for each data set. A Section header (for each data set) is added on the line above the data. Here's a snapshot of the code:



Have fun playing with this VI by customizing it to your specific needs.

Cheers!

Message Edited by Philip C. on 09-28-2005 01:37 AM

[Mully]

Thanks Philip C!!!

I will try to figure out what you have writen and change it for my needs!

Thanks again!

Mully

[Mully]

Philip C

I tried to open and run your vi you were kind enough to write but I get a version error. I have Labview version 7.0 and your vi was created in 7.1.1 I think.

Any suggestions?

Thanks

Mully

[Philip_Courtois]

No problem, here it is...