how can i link data from a strain gage vi to an excel sheet i all ready have both on my block diagram what can i do to link them. thanks

[mikeporter]

Check out the examples dealing with writing to Excel spreadsheets. If you need information on how to interconnect things in LV in general, go through the Getting Started documents that ship with LV.

Mike...

[loni]

thank you mike i will look for this information

[loni]

Hi Mike,

Mike i found the example on writing to excel this was the best one because i am using this one for my three 8 channel

Thermocouple temperature program, but my temperature program run though a bundle to the graph through a cluster to array out to a

Build array through a transpose 2D array and then to a number to fractional string.

I removed the bundle arrays and strings because this did not work with the strain gage program

And the get strated info did not have what I think I am looking for.

I tried the instrument I/O Assistant VI but I am not suer if it is working

And I keep getting an Err(-2146827284) at the set cell value vi thats in the loop called Lable Row column this is were it stops.

can you help thanks 

[mikeporter]

Can you post your code?

Mike...

[loni]

Hi mike,

please see attachment and please let me know if it went through

and thanks for you help.

[mikeporter]

If you change the polymorphic DAQmx Read from a 1D waveform output to a 2D DBL output you get something that you can pass into the nested loops responsible for inserting the data. The attached image shows how to insert the 2D output into the rows and columns of the spreadsheet.

The problem is that the acquisition is in a loop by itself so if you want to save the output of each acquisition cycle (rather than just the last one) you will need to move the data writing logic into that loop.

Mike...

[loni]

mike see attachment

[mikeporter]

I don't know what that error message means. The thing I would do is monitor the inputs and make sure that the values going in are all valid.

Mike...

[Coal_Man]

Loni,

That error indicates that you have written more rows of data than is supported by the Excel spreadsheet as documented by this Knowledgebase article:

Why Do I Receive Error -2146827284 When Using the Excel Easy Text VI in a While Loop?

http://digital.ni.com/public.nsf/allkb/23EF6DD43866726C86256D5C00687E51?OpenDocument

It looks like in your code you are using the report generation toolkit to generate the Excel file.  If you have more than 65,536 datapoints, then you will get the error you mentioned.  As Mike suggested, you may be just as well off to use the write to spreadsheet file VI which writes a text file that is only limited by the amount of disk space you have and the type of disk you are saving to.