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 |
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.
|