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***


Keep up to date on this post and subscribe to comments

November 22, 2019 - 11:18am

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.