TestStrand propertyLoader from XML based file

[Yuri_IL]

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!

[EdgarU]

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.