Importing multiple columns of an excel as a table into the testCaseDesign section
Hi,
I am trying to import multiple columns (H:Q) as a table into the testCaseDesign section using the RQMExcelImporter utility.
I am using the 6.0.5 version of the software.
Is there a way to do so?
I am using the below config setting.
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=Table(1).[H:Q]
One answer
Please refer to https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
for the modifier: HTML() and its sample table script to be included in your excel so that you can have multiple columns in test case design section.
Comments
@Don Yang,
I even tried the HTML command and its underlying table tags to create table, but it wont account for the multiple tables having different rows for one another.
the HTML() command will not help me in this case and also I would have to write the entire html code for table definition which is cumbersome considering the different tables with different dimensions( rows & columns).
Is there a more generalized way to get multiple tables (I have 6-15 tables to be imported to create different testcases) with different number of rows?
Also if you can share the config file settings, that would be great.
I had multiple columns created for one table before in my local test and that's where I referred to previously. There is a workitem discussion on this, see below:
I am not aware of any other way to achieve what you want to do using ExcelImporter.