Reading Excel Data In Teststand Using ActiveX

[Nisarg]

Hello All,

I was Trying to read Excel data In Teststand without using Labview and found the solution with  ActiveX. Though I am not expert with ActiveX but could developed the Teststand Sequence which can read excel data using the ActiveX code module.

Sharing the Screen Shot as well as Sequence file herewith.

You need to Define two inputs:

1)Parameters.Excel_File path 

2)Parameters.Sheet_Name

Output: You will get  2D data into Local.Excel_Data which is 2D String Array in this code(Change the datatype as per the datatype of excel data)

Kindly Suggest if any any correction or any guidelines  to follow using ActiveX with this code.

[WireWeaver]

I just wanted to make a note that starting with TestStand 2016, the Property Loader supports loading from .xlsx format and starting in TS 2017, data streams support loading from CSV. Depending on the goal, one of these options may be a better solution than using Excel's ActiveX interface.

[Nisarg]

@WireWaiver

Yes, using Property Loader is Better option then ActiveX.  But As of now i am still using Teststand 2014..