It's all about the answers!

Ask a question

Importing multiple columns of an excel as a table into the testCaseDesign section


Manjunath RM (212) | asked Oct 10 '18, 11:12 p.m.

 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



permanent link
Don Yang (7.7k21114139) | answered Oct 12 '18, 1:09 a.m.
edited Oct 12 '18, 1:09 a.m.

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
Manjunath RM commented Oct 12 '18, 1:31 a.m.

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


Don Yang commented Oct 12 '18, 2:02 a.m.
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.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.