Overview

Test Case Extractor exports test cases from a test suite selected by the user to Excel.

Pre-Requisites

  1. .Net framework 4.0
  2. Version of Microsoft Office 2003 or beyond  

Installation

Please run the Test Case Extractor set up file (Test Case Extractor.msi) on your machine. A short cut will be created in Programs Menu as shown below
ShortCut

Usage

User can execute the tool by accessing the created short cut in Programs Menu.

Please follow the below steps to export test cases:

1. Connect to Team Foundation Server and specify the location of the Excel file to be saved. File extension should be either .xls or .xlsx

First Layout

2. A list of available test plans will be displayed in a drop down list only upon successful connection. Select the required test plan

3. All the available test suites for the selected tesplan will be displayed.

4. Select one of the test suites and click 'Generate' Button to export test cases to Excel at specified location.

Final Layout

5. User will be notified by a message once the Excel file has been saved

Notification


Last edited Apr 15, 2011 at 10:13 PM by keerthik, version 6

Comments

suparna Oct 14, 2014 at 12:36 AM 
I have TFS 2012 and I am unable to use this tool,When a select a test plan, the dropdown doesn't get closed and it seems some message boc is present behinf that popup list which I am unable to read. The testplan never get selected. Generate button was never enabled. Any help will be much appreciated.

pravinsorte Oct 8, 2014 at 6:52 AM 
how to decide tfs server during setting

KiranInCodePlex Apr 22, 2014 at 9:51 PM 
Unable to select the test plan. I get the error "Test case extractor stopped working. Close program or debug". I am using visual studio 2012. which is connected to TFS 2010 server

caroleorme Jan 8, 2013 at 8:01 PM 
How do I get the comments to come out on the excel

gmyan Oct 11, 2012 at 10:55 AM 
Hello there : )

Comments/Date Executed and Test Data columns are not being filled after generating the suite (or mother suite) needed. so I'm not having the Test case ID/Test Case steps and expected results after generating. any idea why ?

Thanks in advance,

Georges

MCJ Sep 7, 2012 at 5:08 PM 
Is there a way to export the DESCRIPTION section????

Nefarious Aug 24, 2012 at 9:41 PM 
This is a great tool, thanks.

surya123 Apr 11, 2012 at 6:55 AM 
Awesome!
The steps are very clear.
Thank you!