Question
STAIDLOGIC LLC
CA
Last activity: 23 Jun 2020 14:52 EDT
Issue with Excel Export with images
Hello,
I have requirement to export images and any other tags such as Bold/Italic/Underline in the content to Excel.
Anyone has any idea how to export images from custom Pega app within Excel template?
***Edited by Moderator Marissa to update Platform Capability tags****
Healthfirst
US
from where you are sourcing the data (Bold/Italic/Underline/image) to excel?
StaidLogic LLC
US
John, The export is happening from Rich Text editor to excel and its working good if we do the export to pdf.
Pegasystems Inc.
US
Hi Harinath
Can you try including the RTE in a table and then using the method here to check if that helps ?
https://collaborate.pega.com/discussion/export-data-data-page-excel
(OR)
you can make the RTE a column in a report definition and then export to excel
(OR)
source the table from a RD and use the pzRDExportWrapper function to convert to Excel.
Healthfirst
US
what you mean by RTE column?
StaidLogic LLC
US
Hi Krithiga,
The current design and implementation in my application to export the data into excel & pdf, is as per the below link steps:
https://collaborate.pega.com/discussion/export-data-data-page-excel
Now, we tried the below approach to export the data (Rich Text Editor -RTE- field) to excel with images. However, it did not work and the exported excel has the image information like below tags:
Approach: *** source the table from a RD and use the pzRDExportWrapper function to convert to Excel.
<u><strong><img src="../datacontent/Image/rteImages/Workbasket1592838850835.png" style="height: 292.988px; width: 634.941px;" />Project Notes Test</strong></u>
Note: I have used this activity "pzRunReportAndExportResult" as a reference to build the above logic.
**Our requirement is export the "Rich Text Editor" field information to excel with images if it has any...
Thanks