Configure Excel importer to get info from different Excel sh
Hi,
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,
Ana
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,
Ana
One answer
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.