RQMExcelImporter: CR LF not being recognised during import
Hello,
I'm trying to import text from an excel sheet into the "Test Case Design" tab for a Test Case, but for some reason the CR LF tag is not being recognised, and so all text is being put onto a single line.
For example, when I import one of the samples:
Start furnace
Wait until it hits 10000 degrees
Toss in hammer
Send in coyote to check on hammer
Stop and cool down furnace
Ensure hammer looks good (coyote looks a little crispy is acceptable)
the result is:
Start furnace Wait until it hits 10000 degrees Toss in hammer Send in coyote to check on hammer Stop and cool down furnace Ensure hammer looks good (coyote looks a little crispy is acceptable)
When analysing the XML file in notepad++, I see:
Start furnace
Wait until it hits 10000 degrees
Toss in hammer
Send in coyote to check on hammer
Stop and cool down furnace
Ensure hammer looks good (coyote looks a little crispy is acceptable)
Has anybody else experienced this problem or does anybody know how to resolve?
Thank you and best regards,
Andrew
I'm trying to import text from an excel sheet into the "Test Case Design" tab for a Test Case, but for some reason the CR LF tag is not being recognised, and so all text is being put onto a single line.
For example, when I import one of the samples:
Wait until it hits 10000 degrees
Toss in hammer
Send in coyote to check on hammer
Stop and cool down furnace
Ensure hammer looks good (coyote looks a little crispy is acceptable)
the result is:
When analysing the XML file in notepad++, I see:
Wait until it hits 10000 degrees
Toss in hammer
Send in coyote to check on hammer
Stop and cool down furnace
Ensure hammer looks good (coyote looks a little crispy is acceptable)
Has anybody else experienced this problem or does anybody know how to resolve?
Thank you and best regards,
Andrew
One answer
Hello again,
If anybody is interested, I was able to find a solution:
1. Run the following script to replace all LF with <br>
2. Import as usual
Please note that this does not preserve advanced formatting like coloured,bold , italic , and underlined text.
Regards,
Andrew
If anybody is interested, I was able to find a solution:
1. Run the following script to replace all LF with <br>
Sub replaceLf()
Cells.Replace what:=vbLf, replacement:="<br>"
End Sub
2. Import as usual
Please note that this does not preserve advanced formatting like coloured,
Regards,
Andrew