It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908
×7,383
×5,997
×1,211
×750
×482
×139

question asked: May 06 '20, 1:54 a.m.
question was seen: 1,650 times
last updated: May 06 '20, 6:45 a.m.

Related questions

FAQ - How this Forum works

RQM Excel Import

0
Sudarshan M (107●1●21) | asked May 06 '20, 1:54 a.m.

This is regarding “RQM Excel Importer” utility. I am trying to import table of excel into section of my test case using HTML() function in config file.


// Start looking for test cases on row 2
testcase.XLSStartRow=2
testcase.XLSArtifactID=A
testcase.dc:title=B
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition", "RQM-KEY-TC-PRE-COND-TITLE")=HTML("<table border='1'><thead><tr><th>" & C & "</th><th>" & D & "</th><th>" & E & "</th></tr></thead><tbody><tr><td>" & C & "</td><td>" & D & "</td><td>" & E & "</td></tr></tbody></table>")

This helps me to import single row of table into that particular section, but not the complete table.
ID Test Case column1 column2 column4
1 test case 1 data 1 data 1 data 1
data 2 data 2 data 2
2 test case 2 data 3 data 3 data 3
data 4 data 4 data 4
data 5 data 5 data 5
data 6 data 6 data 6


I want to import able from C1 to E3 and for test case 2 from C4 to E7. Currently I am able to import only single row for every test case.

Kindly suggest the possible ways

Accepted answer

0
permanent link
Mehul Patel (969●5) | answered May 06 '20, 2:46 a.m.
FORUM MODERATOR

Sudarshan,


As you are enumerating each row for testcase attributes, you will be able to process only one row for HTML table. If you need to have multiple row for HTML table then I would suggest to spread entire table data in a single row and let configuration syntax prepare table using HTML tags.

Regards,
Mehul

Sudarshan M selected this answer as the correct answer
Comments
Sudarshan M commented May 06 '20, 5:15 a.m.

 hi mehul,


Am not getting your point, could you please explain in brief!

Regards,

Sudarshan M 

One other answer

Most liked answers|Newest answers ↓|Oldest answers

0
permanent link
Mehul Patel (969●5) | answered May 06 '20, 6:45 a.m.
FORUM MODERATOR
Sudarshan,

Change your data as 

C D E F G H
ID Test Case column1 column2 column3 column4 column5 column6
1 test case 1 data 1 data 2 data 3 data 4 data 5 data 6
2 test case 2 data 1 data 2 data 3 data 4 data 5 data 6

and write configuration file as 

HTML("<table border='1'><thead><tr><th>" & C & "</th><th>" & D & "</th><th>" & E & "</th></tr></thead><tbody><tr><td>" & F & "</td><td>" & G & "</td><td>" & H & "</td></tr></tbody></table>")

Regards,
Mehul

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.