LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Adding DAQ data to a template

Hello.

 

I have a question concerning the use of excel templates.  Though there are a number of forum posts dedicated to the topic, I don't quite see how to fit it all together.

 

Currently I have a DAQ with 40 output channels, I am trying to write those results to a pre-formatted excel.

 

My current VI has all the capabilities I wish (See attached Current.vi) except the ability to put the data in a pre formatted excel.

 

The write to measurement VI that I am using is a native part of labview, it seems as though I need to use the Report Generation Toolkit (which I have), though I am not quite sure how to create the template using LV.  I continue to get errors "this is not a labview generated excel".

 

I have also attached my current output (See attached DAQ_OUTPUT.xls) I would like the data to instead look like the slightly formated finished product (Attached DAQ_Output_ideal_final.xls). 

 

 

Specifically, I would like to create a template [this template would be exactly (Attached DAQ_Output_ideal_final.xls)  minus the data], then use the for loop within my current VI to determine the target row of insertion.  I would like to use the iteration count (i).

 

Apologies, as I am sure this question has been answered I simply can't make heads or tails of the report generation toolkit; I imagine that since my desired result is relatively simple, there could be a work around using only the write to measurement VI  Wrong term.

 

Thanks

 

 

 

Download All
0 Kudos
Message 1 of 5
(2,493 Views)

Do not use a Template.  Generate the Excel Worksheet "on the fly" using the Report Generation Toolkit tools.  I showed how do to this a while ago -- look for the post called Revised "Generate Excel Report" Example, which includes the revised Demo.

 

BS

0 Kudos
Message 2 of 5
(2,460 Views)
0 Kudos
Message 3 of 5
(2,445 Views)

That's the one.  I think it is self-explanatory -- try it out, experiment with adding stuff, see if it will suit your needs.

 

BS

0 Kudos
Message 4 of 5
(2,419 Views)

Thanks,

 

Ill give it a go.

 

0 Kudos
Message 5 of 5
(2,414 Views)