NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

How to read test data from excel in test stand with out labview

Hi Team,

I have some test data in excel sheet which i need to use to test dotnet dll using test stand.

can you please inform me the possibility of storing data from excel into array of test stand.

 

I have seen Test stand examples for limits loading using property loader,but it is useful only for properties.

please guide me how to extract testdata from  excel into test stand variables(array) without using Labview

0 Kudos
Message 1 of 3
(3,659 Views)

Hi,

 

You can use the property loader to retrieve data from a xls file into your TestStand variables.

 

The easiest way to set up an XLS file is to use the Import/Export tool in the Tools Menu and export your array to your file.

 

Then you can setup up your PropertyLoader step to load your array at runtime.

 

There are examples using the PropertyLoader to load variables on the website and in the TestStand Examples.

 

Regards
Ray Farmer
0 Kudos
Message 2 of 3
(3,656 Views)

The Property Loader section of Appendix C, Database Step Types, of the TestStand Reference Manual has some info about reading information from Excel files. Might be something worth checking.

 

http://www.ni.com/pdf/manuals/373435e.pdf

Tom
TestStand Documentation
0 Kudos
Message 3 of 3
(3,632 Views)