Question
Accenture
IN
Last activity: 6 Apr 2022 5:41 EDT
Generating Excel with Images at desired position is feasible?
Hi Team,
I have a requirement to capture attributes and images from user through UI and same details need to be captured and generate as an Excel with images in particular position.
Can we generate Excel with images in Pega ? If so, let me know the OOTB Functionality available for this
Accepted Solution
Updated: 6 Apr 2022 5:41 EDT
Pegasystems Inc.
GB
Wells Fargo
IN
@Kavitha Kumar - Did you find any feasible solution for exporting images from PEGA to Excel. I too have a similar kind of requirement.
Accepted Solution
Updated: 6 Apr 2022 5:41 EDT
Pegasystems Inc.
GB
@Kavitha Kumar @AjayKumarG3734 Our SME's have commented that the images will not be rendered with the new Export to Excel and this is not a feasible one to make.
The functionality can be achieved through Export to PDF but the new Export to Excel doesn't support this. With the old export we were displaying the HTML directly but since the introduction of New Export to Excel, the Excel is being rendered using Apache POI jars - it does not support image rendering on Export.
See documentation Activities for integrating cases with Excel documents , getSvcImage(key), getOperatorImageInsKey()
@Kavitha Kumar @AjayKumarG3734 Our SME's have commented that the images will not be rendered with the new Export to Excel and this is not a feasible one to make.
The functionality can be achieved through Export to PDF but the new Export to Excel doesn't support this. With the old export we were displaying the HTML directly but since the introduction of New Export to Excel, the Excel is being rendered using Apache POI jars - it does not support image rendering on Export.
See documentation Activities for integrating cases with Excel documents , getSvcImage(key), getOperatorImageInsKey()