RQM Excel Import
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
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
One other answer
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