How to set the default Excel cell format when opening XML to XLS using an existing stylesheet​?

[Akiel]

this has been reposted as a new thread as was originally posed in another thread but deemed suitably different to warrent a new thread

I am opening an xml report in excel using the horozontal stylesheet (teststand 3,5 and excel 2003) is there a way to open the xml file using the stylesheet without the operator needing to specify whether to use horozontal or open it without a stylesheet. This is proberly more an excel problem than teststand but I believe others may have had this problem

Thanks in advance

[Robert.L · Accepted solution]

Hi Akiel

I have looked into the issue that you are having an stumbled across the forum that you originally posted the question in.

There is a National Instruments knowledge based article that covers importing XML into Excel with the formatting. I have placed a link below.

How to Import a TestStand XML Report into Microsoft Excel 2003 with Proper Formatting?

http://digital.ni.com/public.nsf/allkb/1E52D0A45F24B1348625747B000D2FC1?OpenDocument

[Akiel]

Thanks for posting this solution. I found this method by other means. For us an acceptable solutiom was to set teststand to save the testreport as tempreport.xml and launch excel as the viewer. In excel set the auto_open macro to open tempreport.xml (as described in the knowledge base article) this macro also locks all cells so the operator cannot accidentally make changes. Then add the auto_close macro to save the file as xls. More functionality/control can now be added depending on application

Thanks for your time