TL 1.8.3 - Export XML and Import into Excel 2007

[clarkpd6]

I have exported a test case from TL 1.8.3 as an XML file. I have followed the instructions as noted in prior posts. All good so far.

But when I open the XML file in Excel 2007, all the tags etc are displayed as text in one cell.

For example, the test case Steps are displayed in one cell as:

<p>Step 1: <a href="http://xx.x.xx.xx/testlink/index.php">Logon to reporting server</a></p>
<p>Step 2: Select required report</p>
<p>Step 3: Select the year of interest</p>
<p>Step 4: Select the campus</p>
<p>Step 5: Run the report</p>

NB: I have tried the instructions, plus other permutations for opening the XML file in Excel 2007, but always the same result.

I have also copied the XML (for a test case) from the documentation (pdf), saved as XML file and imported into Excel. Same result as above.

If I add a step in seperate rows in Excel and then import into TL, I get a seperate test case for each row.

Any suggestions as to what the issue could be?

Any help would be much appreciated.

[PrakashC]

I am also facing the same issue.

Is there any way to remove HTML tags when I import XML into EXCEL?

Please help!!!!

[clarkpd6]

I gave up on trying to export an example testcase to excel from within Testlink.

If you want to use Excel to document a test case with subsequent import into Testlink, then follow the instructions below:

A1: name, B1: summary, C1:steps, D1:expectedresults. These are set.

A2: text you input for test case name, B2: text you input for the summary, C2: text input for first step, then <alt><enter> together to insert a new line in this cell, enter text for the next step, then <alt><enter> and so on for each step. D2: input is the same as for C2.

ie all steps are in the one cell. Use <alt><enter> to insert a new line within a cell. This will create a new line in a test case when it is imported.

Each row in Excel is a seperate test case ie A3 is a new test case.

Have fun

[/list]