Posted: 22 Nov 2019 7:08 EST Last activity: 22 Nov 2019 11:18 EST
Excel sheet data with different colors
I Have Requirement like i am hitting the service getting some result in the page list i have results like erroe orders and success orders that moment i download the excel and open nee to see columns in different colors eg:fault orders in red colors success order in green color i have Template in pega how to achive this?
***Edited by Moderator: Lochan to update platform capability tags***
Unless you are implementing custom code to create a Excel file object and manipulate/write out your data into it, I do not think any OOTB excel generation feature in Pega would allow you to do this. Any kind of requirement e.g. applying a diff format/color etc. in my mind would be treated as a manipulation to be done in the Excel file outside of Pega context using macros/formulae etc. I'll let others comment on they think about this as well. Thanks.