Question
Capgemini
IN
Last activity: 16 Feb 2017 5:04 EST
Export Colour codes from Report Definition to Excel
Hi All,
We have a new requirement in which we have a Report Definition(RD) where we are highlighting few fields based upon criteria. We have achieved that by adding HTML formatting beside each and every target property in the RD form itself.
Noe we have to export the same view with the color codes to the default OOTB export to excel feature. I meant to say the exported excel should also have the same color codes as displayed in screen. Please advise how to easily achieve this?
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
IN
Hi Arindam,
I have tried a sample use case (added background color for one of the columns ) in our local machine. Even I am not able to observe the background color.
Upon further checking, we could observe that we cannot export all the styles formats defined in HTML to Excel while exporting to Excel, but the same can be done for exporting to PDF.
I believe, this can be treated as an enhancement request and the feature can be introduced in future pega release.
Hope this answers your query.
Note: attached inhouse sample
Best Regards,
Mounika
Capgemini
IN
HI Mounika,
Thanks a lot for the help. This is really very much appreciated!
Thanks
Arindam