Create NI TestStand Sequence file from Excel file

Question

I have a Microsoft Excel file which have two columns and sixteen rows of Data. As image attached.

Excel Reference Image to import sequence data to NI TestStand

Please I need help to Import excel data to NI TestStand sequence file. This excel file for just reference only.

Please let me know if there is any confusion. Thanks

score 0 · Answer 1 · answered Dec 01 '17 at 22:26

0

Is the data you are referring to in the Excel file properties? Or did you want to actually create Test Steps from Excel file?

If it's properties to load, then use the Property Loader Step. To make it easier, you can do an export which will create the XML layout which you can modify the data with the one in the Excel.

As far as creating a Test Step based on Excel file, that's not how TestStand works.

answered Dec 01 '17 at 22:26

pinguu

41
3

Actually i want to create test steps of 300 sequences. – Shahid Saddique Dec 01 '17 at 22:44
refer to this example. this may help you with that. [link](https://forums.ni.com/t5/Example-Programs/Building-a-Sequence-Using-the-TestStand-API/ta-p/3527244) – pinguu Dec 04 '17 at 14:08
pinguu i didn't have access to this location. please suggest another example. Thanks – Shahid Saddique Nov 24 '20 at 18:46

score 0 · Answer 2 · answered Sep 23 '22 at 00:23

You can do this with Import Properties.

I would first create a test sequence as a model and export the properties from it. Then you can use that as a template to import the properties you have in your excel file.

From what I see from your example though. It may be easier to just manually create the sequences and steps, if that's all there is. If you have to create 300 steps or sequences it may be a better idea to utilize loops or create a module.

Create NI TestStand Sequence file from Excel file

2 Answers2