LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Excel Test Report

Hi All,

 

I have managed to make a few nice self test programs using labview now, and feel l'm starting to get into the swing of it! One thing thats letting my programs down is the lack of data analaysis at the end. I would like my programs to automatically generate test reports in Excel. Up to now ive only managed this very simply using .txt files etc.

 

I know there is an example of an excel test report in example finder, but there is mention of using place holders in excel which i have never come across before.

 

any help/ advice would be appreciated

 

thanks,

 

richard.

0 Kudos
Message 1 of 4
(1,646 Views)
Hi for Report generation there is specific toolkit: LabVIEW Report Generation Toolkit for Microsoft Office: http://sine.ni.com/nips/cds/view/p/lang/en/nid/5769
-You can start here on how to use the toolkit: http://www.ni.com/white-paper/3178/en/ and http://www.ni.com/tutorial/3201/en/
-In Excel, the easiest way to define placeholders is to use named ranges to define the place where data has to be inserted.
Thanks
uday
0 Kudos
Message 2 of 4
(1,630 Views)

Several years ago, I submitted (in response to a Question on the Forum) a revised Example for generating an Excel Report using the Report Generation Toolkit.  If you search in the Forums for Revised " (that is, type the word "Revised" and then a single Quotation mark), it should pop up this example.  If you have the RGT, creating Excel Reports in LabVIEW is fairly straight-forward.

 

Bob Schor

 

0 Kudos
Message 3 of 4
(1,618 Views)

Here is the gist of it. 

 

Example_VI_BD.png


aputman
LabVIEW 2017
LabVIEW Programming
0 Kudos
Message 4 of 4
(1,597 Views)