Capturing a set amount of data point.

[bsteinma]

Hello,

I am using LabVIEW v7.5 for a project I am currently working on and am recording signals from 6 physical channels.  I have a couple of questions about the write to spreadsheet VI.  First, when I write to a spreadsheet, transpose it, then open it in excel or another spreadsheet application, do the columns correspond to the channel that the data came from?  Second, I was wondering if there is a way that I can specify the VI to record a set amount of data.  Since EXCEL can only plot a maximum of 32,000 data points I would like to sset the VI to only record that many data points so I don't have to manually delete them when I would like to plot them.  Lastly, this is something I have been curious about for a while, is there any way that I can append a header to the columns without manually adding it after opening the data in EXCEL.  I will appreciate any comments or feedback

thanks so much,

bsteinma

[mikeporter]

The answers to your questions are: Yes and Yes.

To see how to acquire a set number of samples refer to the examples that ship with LV. (Hint: this is always a good place to start when trying something you haven't done before.)

Mike...

Message Edited by mikeporter on 02-17-2009 03:22 AM

[Robbob]

Or you can write to a .xlsx spreadsheet, which goes from 256 columns and 65,536 rows in Excel 2003 to 16,385 columns and 1,048,576 rows in Excel 2007.