How to Read an XLSX File in TestStand

Updated Jun 25, 2020

Reported In

Software

  • TestStand
  • LabVIEW

Issue Details

I store several data in a xlsx file that I want to use in my MainSequence but how can I import the data directly in TestStand?

Solution

You should use a code module to read the file and then store the data using parameters.
If you are using a LabVIEW code module, because there is no built-in function to read xlsx file, you must use the ActiveX components to interact with excel.

Additional Information

ActiveX is a set of Microsoft technology that allows an application to use method of another software. A typical example is using Excel sheets in a LabVIEW program.
If you want to learn more about how to use the ActiveX in LabVIEW, please see the following link: ActiveX and LabVIEW