labviewteststand

Transferring data from Excel to TestStand and then to LabVIEW


I have presently created a small project in LabVIEW to understand the usage and communication between LabVIEW and TestStand. The VI has 8 switches and 8 lights. Is it possible for me to create an Excel file from which the TestStand will read and send these I/O parameters to LabVIEW in order to operate those switches? I am very new to TestStand but I use LabVIEW a lot in day to day life. So any help is appreciated.

I would also like to know how the Excel file should look like.


Solution

  • So, I have finally figured out how it works. To get the format of the excel file, I exported the properties into an excel file( the ones I want to change in Labview). I created fileglobals and exported it to get an example of Excel sheet. I inturn used this Excel file to change the values of Fileglobals or even add more of fileglobals or parameters.

    Then I defined the inputs of the Labview using connectorpane, I connected all the inputs and outputs in labview to a cluster. I can do it in this Program but I am yet to figure out how to do it when I have a lot of inputs and a lot of outputs. If I use clusters everywhere, the CPU usage increases and it's not very efficient to use clusters everywhere. Because I work with labview programs where there are over 150 inputs and outputs. So clusters are not very feasible. But for smaller amount of Inputs/Outputs, it works well.

    Then I used result processing to send the input/output to a database which I created using microsoft SQL server studio 18 and edited the tables using database viewer which comes along with TestStand. And then exported this data into an excel sheet.

    Works perfectly fine.

    Presently on to the next step where in I wanna write input output as well into excel. My present Program writes only Pass/fail or numeric limits in excel. On to the next step now. Will write here when I figure that out as well :)