How to export all test cases from QualityCenter to excel sheet? I am looking for above task to be done in one shot. Suppose if i have 1000 testcases in QC, I want to export all 1000 test cases using single option and not exporting one by one.
If you want to get ALL your test cases out of QC and put them in a spreadsheet, you'd have to do some SQL magic to get them out of the database. You'd have to create a query to select all the test cases out of the "test" table, and then tie those rows to their associated steps in the "step" table. You could then put that data into a spreadsheet.
Well it's not all in one shot but you could try using the Document Generator to generate a word document with all of your test cases in table/tabular format. From there you should be able to get them into excel fairly easily.
If you don't mind a little time. You can create a regular report (not the document generator). Use which ever subreports are necessary to get the level of detail you require. Set the report to show all on one page.
When the report has compiled and is visable in Quality Center, Right click on any blank area and click Exprot to Microsoft Excel.
This can be a very ugly way to do it (notice I didn't say solution). But it will get the information in Excel.
You could always save the report to HTML, and open it in Excel. Although, it works, it isn't pretty either.