xls to html

[mday]

The xml report with the expand.xls format has the functionality we are looking for. It allows expanding and collapsing of results and defaults to have only failed cases expanded.

We want to archive test results in a stand alone HTML format, not as an XML report that requires an .xls file. I noticed that teststand is generating a temporary html file from the XML file. This file is removed when the report is closed in teststand.

Is there a way to have the HTML file generated from the XML / XLS to persist and be saved as the report results ? I think I may just be missing a report option somewhere.

[asbo · Accepted solution]

I assume you actually mean XSL not XLS (that's a spreadsheet ;)). That temporary report is generated by the Sequence Editor, not the TestStand engine. If you'll always be running through that specific OI, you could add a step in your process model to copy it elsewhere. Otherwise, you'll have to add your own code to make the conversion yourself; I believe that the sequence editor uses the MSXML package, which shouldn't be too tought to interface with.

[Anna_K.]

Hello,

You can choose the report format under Configure >> Report Options. On Windows 7/Vista the reports are saved by default at C:\Users\akozmins\AppData\Local\Temp\TestStand\Reports and at the equivalent location on XP etc.

Does that answer your questions?

[mday]

You are correct. MSXML can even be accessed from a perl script. We can now change out xml files into stand alone HTML documents during a post processing step if we have to. This gives us some flexibility. Thanks, I appreciate the help even if it took me a while to reply.