NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

How to Change Testand Report Format to Excel instead

What is the best Way to change my Teststand Report Format to Excel Instead of XML, HTML, ATML, ASII, etc, ...

 

Should I do this inside of the Reporting Process Model, reporting to Excel is not an option by default.  Is there a simple way to make Excel the default Datalog output From Teststand?  Or will I have to customize my Teststand Sequence to do this like before?

0 Kudos
Message 1 of 5
(3,400 Views)

Process model plugins are the proper answer here.  From the TestStand help this gives a pretty good explanation: https://www.ni.com/docs/en-US/bundle/teststand/page/process-model-plug-in-architecture.html

 

It's not trivial to do what you want.  You have to recurse through the MainSequence results and inject the data into the correct cells. 

 

I've written several Excel plugins.  The trick is knowing how to map the data from your test to the proper sheet and cell.

 

Let me know if you have specific questions or thoughts.

 

jigg
CTA, CLA
testeract.com
~Will work for kudos and/or BBQ~
0 Kudos
Message 2 of 5
(3,383 Views)

Hi 

 

I need help, how can I change teststand report to Excel format

0 Kudos
Message 3 of 5
(2,014 Views)

There is no out of the box (Test Stand box) solution for this. You can write your own plugin as Sam explained. To do so, you will need to use Excel API (you will find plenty of examples how to do this in LabVIEW in the internet).

 

Other option (not perfect though) is to generate CSV file. Excel can deal with it quite well.

Michał Bieńkowski
CLA, CTA, CPI

  1. Did someone devote their time to help solve your problem? Appreciate it and give kudos.
  2. Problem solved? Accept as a solution so that others can find it faster in the future.
  3. Contribute to the development of TestStand by voting on the TestStand Idea Exchange.
0 Kudos
Message 4 of 5
(1,981 Views)

Hi, 

In addition to the options listed in this post, you can try to use Model Plug-in - Simple Text Report - NI

Regards, 

Anand Jain

NI

Message 5 of 5
(1,945 Views)