Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Manjunath RM
(21●2) 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]


0 votes

1 answer
4,709 views
0 votes

One answer

Permanent link
Don Yang
(7.7k●21●114●139) 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. 

1 vote

Comments
Manjunath RM
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
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: https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=69028 I am not aware of any other way to achieve what you want to do using ExcelImporter.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,623
× 6,180

Question asked: Oct 10 '18, 11:12 p.m.

Question was seen: 4,709 times

Last updated: Oct 12 '18, 2:02 a.m.

Related questions
Confirmation Cancel Confirm