It's all about the answers!

Ask a question

RQM Excel Import


Sudarshan M (10715) | 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


permanent link
Mehul Patel (9545) | 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



permanent link
Mehul Patel (9545) | 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.