NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

TestStrand propertyLoader from XML based file

Hi,

 

I have XML file, how to convert it in a smart way to XLS or comma separated file that after it i can load it automatically via PropertyLoader.

I use TestStand 2021, any one has already ready to use parser from XML to XLS or comma separated file?

Any one knows C#/Python based library that can help convert XMl file to XLS or comma separated file?

 

Example of XML file is:

<?xml version="1.0" encoding="UTF-8"?>

<projects>

<COMMON>

  <StationGlobals>

              <Station.DBName>testDB</Station.DBName>

  </StationGlobals>

  <FileGlobals>

  </FileGlobals>

</COMMON>

<ProjectX>

  <StationGlobals>

   <psequence delay=5>GPIB5::INSTR0::KEYSIGHT,GPIB6::INSTR0::KEYSIGHT,GPIB5::INSTR0::KEITLEY</psequence>

   <dsequence>GPIB3::INSTR0::34401,GPIB21::INSTR1::34401</dsequence>

   <Station.S enabled=TRUE ></Station.S>

  </StationGlobals>

  <FileGlobals>

   <valid1>9</Ampl_valid1>

   <valid2>9</Ampl_valid1>

   <valid3>9</Ampl_valid1>

  </FileGlobals>

  <Locals>

   <corners>

               <H VOLT=2></H>

              <C VOLT=1></C>

   </corners>

  </Locals>

  </ProjectX>

 

Thank you!

 

Thank you & Best Regards

*I use LabVIEW 2018 & TestStand 2021 versions
0 Kudos
Message 1 of 2
(972 Views)

Hello Yuri,

 

For performing XML to xls conversation by Python, you can refer to this link: Convert XML Spreadsheet to Excel file in Python | EasyXLS Guide

 

Best regards.

0 Kudos
Message 2 of 2
(929 Views)