It's all about the answers!

Ask a question

Configure Excel importer to get info from different Excel sh

Ana Lopez-Mancisidor (25648966) | asked Nov 19 '09, 3:53 a.m.

Does the Excel importer for RQM work to get info from different sheets
included in the same Excel file?

I have an Excel file with two sheets (the first one includes info about
the test plan and the second one has the list of test cases associated
with the test plan) that I would like to import automatically into RQM
using the Excel importer.

Any info about how should I configure the cfg file to map attributes
from different Excel sheets?

Many thanks,


One answer

permanent link
Hao Wan (1.5k35) | answered Jun 11 '12, 3:27 a.m.
Hi Ana,
first you need to specify the worksheet id
e.g.  testplan.XLSWorksheetID="test plan sheet"
testcase.XLSWorksheetID="test case worksheet"

and using testplan.testcase=Link(E)  or Link(E2)   // a cell or column depending on the structure of your worksheet.

note: if a testplan with more than one testcase, you can put the testcase link in one excel cell and separate with a new line.

Your answer

Register or to post your answer.