To do so, we have to make sure that the columns used in excel match with the fields/data which we enter in QC. I will explain the steps using an example,–
2. Now, next step would be to install the excel addin for QC. To do so, follow the following steps:-
a. Launch Quality Center
b. Click on Addins link
c. Click on More QC Addins link
d. We can go through the Guide also or this step can be skipped
e. Click on “download …” link
f. Follow the steps of installation
g. Restart the system
9. Now, we have to map each column in our excel sheet to specific fields in QC. To do so, click on following from the quality center valued displayed in window and give their respective column numbers.
11. Above steps will upload the test cases in QC at path ‘Iteration1ModuleABCxyz’. We can view them in Qc now.
Donot mention the root directory.
If the xyz folder is not present at Iteration1ModuleABC in QC, it would be created.
similarly, if the ModuleABC folder itself is not present at Iteration1, The folder and subfolder mentioned would be created.
Click the below links for further read on same topic:
Steps to download and install MS Excel Add-In for HP QC/ALM 11.5x