RQM Excel Import

Sudarshan M (107●1●13) | 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
1	test case 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 (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

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

It's all about the answers!

Related questions

RQM Excel Import

Accepted answer

One other answer

Your answer