HTML Tags in Exported Excel File

General
, ,
1

Hello!

My team and I are currently working through a situation related to insights. We have an insight configured to display some data in a table. The table displays records from a case type within our application. The table includes a column that displays content captured in a text (paragraph) property. Within the case type the text (paragraph) property is configured to display at rich text.

When the property is added to the insight, the value displays cleanly and as expected. However, when a user clicks Pega’s OOTB “Export to Excel” option on the insight the exported file displays HTML tags wrapped around the property’s content. We’ve tried updating the column format within the source report definition, but that has not resolved the issue. How do we ensure that the value displayed is what is exported to Excel without the HTML tags?

Any advice on this issue would be greatly appreciated!

Thanks,

Tess

Property displayed in the Insight:

DescriptionInInsight
DescriptionInInsight297×112 1.9 KB

Property displayed in the exported Excel file:

DescriptionInExcel

Property Configuration:

RichTextProp
RichTextProp680×391 11.9 KB

Report Definition column formatting:

ColumnFormat
ColumnFormat682×396 9.03 KB

2

As an alternative, If you’re using the Text(paragraph) as plain text instead of RichTextEditor, then it should work as expected.

3

While I appreciate that this is a possible solution, it would result in our users no longer having access to the helpful formatting and styling features provided with a rich text editor.

4

Since RichText supported html format, that’s why we see the HTML tags as part of the data while storing and retrieving. Please check this post.