how to parse xml and import to execel

[Mandya]

pls let me know how to parse XML file and import all data to execel sheet.

[JÞB]

Not sure what this has to do with TestStand

[Mandya]

 I would like to create a seq  that takes the XML file and when the user inputs the specific array name they are looking for it goes into the xml file finds the entire array under that name and displays it in an output indictor to be viewed on the .xls file under each tab.

each array has its own unique name and, require multiple arrays to be placed under each tab in the.xls sheet.

[Frank_L.]

Hi Mandya,

This is outside of the normal use case for TestStand. It would be best to use a code module (developed in LabVIEW, C, or any other language) to accomlish this and then call it from a step in TestStand. You can find examples on ActiveX here:

http://forums.ni.com/t5/NI-TestStand/Controlling-Excel-from-TestStand-with-Activex-Automation/td-p/1...

I hope this helps.