3

I'm using an Excel report from Analysis view to export the design steps to Excel:

SELECT DESSTEPS.DS_DESCRIPTION
FROM DESSTEPS

However, DESSTEPS.DS_DESCRIPTION field looks like this:

<html>
<body>
<div align="left"><font face="Arial"><span style="font-size:8pt">Call transaction </span></font><font 
face="Arial" size="3"><span style="font-size:10pt">SU01</span></font></div>
</body>
</html>

and in Excel the corresponding cell looks like this:

<empty line>
<empty line>
<empty line>
<empty line>
Call transaction SU01
<empty line>
<empty line>
<empty line>
<empty line>

Is there a way to convert the HTML content to plain text (in the SQL query or in post-processing) in order to avoid blank lines in Excel?

Environment:

  • ALM 11
  • Oracle 10
|improve this question
  • I'm here again and I continue with this problem, I get 4 lines blank with html fields using Excel report, do you find the answer to fix it?... – user1880 Jan 13 '12 at 22:01
  • Hi Tania! Could you move your comment from answer to comment under the question? – dzieciou Nov 2 '12 at 22:01
  • Converted Tania's answer to a comment - thanks for the heads up @dzieciou – testerab Nov 2 '12 at 23:41
2

What operating system are you using? If it is *nix, you could use html2text.

|improve this answer
  • Sadly, Windows only environment :( – alexandrul Oct 7 '11 at 22:29
  • 1
    If you download cygwin, then you could download and build html2text on the command line. – user8128167 Apr 4 '16 at 19:42
0

If your goal is to export in Excel the description of test step, the best way is to use, in the module dashboard, the "Excel Report". With this tool, you can create an Excel file with :

  • for each request SQL an Excel sheet with the result of your request
  • you can create VB code who is execute in post processing (to add graph, specific instruction, ...)

In the database, QC save all htlm tag for description. With "Excel Report", the result is only the text without html tag.

|improve this answer
  • It is an Excel report, the problem is that in a cell the text has 4 blank lines before and after it. – alexandrul Oct 13 '11 at 6:00
  • Normally you may not see html tag with an Excel report. You can add a Post processing to suppress this kind of information. You must verify version and patch because if I remimber there is a patch for this. If you give me you version and patch I can check for you – OFS Oct 14 '11 at 15:47
  • ALM11 SP2 x64 (the latest, AFAIK) – alexandrul Oct 14 '11 at 16:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.