It's all about the answers!

Ask a question

RQM: Converting XML of Testscript to Excel format


Rajesh Avanthi (10815143173) | asked Oct 30 '14, 5:30 a.m.
Which is the best way to Export test cases from RQM to Microsoft Excel? (along with Actual and Expected results Column) .
Also how to convert this XML of test script to excel format?

One answer



permanent link
Reshma Ratnani (1.1k1) | answered Oct 30 '14, 5:52 a.m.
JAZZ DEVELOPER
Hi Rajesh,

Firstly did you mean exporting TestCase or TestScript? If it was TestCase then goto Browse->TestCases else goto Browse->TestScripts, select the testcases or testscripts respectively which you want to export. Click on Download as Spreadsheet icon. This will give you csv file which you can directly open in Excel. But there is no way to get the Actual and Expected results Column in both cases

Thanks

Comments
Reshma Ratnani commented Oct 30 '14, 5:55 a.m.
JAZZ DEVELOPER

By the way the above way is from RQM UI.

If you have the xmls of TestCase or TestScript then currently there is no utility which converts xml to Excel directly. You need to export the xml to RQM and follow the steps mentioned in above comment to get the Excel file

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.