Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 sravanthi patnamshetty (sravanthip1652)
Altisource Solutions Inc
Software Engineer
Altisource Solutions Inc
IN
sravanthip1652 Member since 2021 3 posts
Altisource Solutions Inc
Posted: Jul 18, 2022
Last activity: Jul 18, 2022
Posted: 18 Jul 2022 6:15 EDT
Last activity: 18 Jul 2022 9:10 EDT
Closed
Solved

Add background color to one of excel cell using pega prpc

We have a requirement, need to highlight cell with yellow color in excel, Generated excel with data from page list property using binary file. For reference I have added attachment

Example:abcd.com should be highlighted in yellow

Any help can be appreciated

 

Thanks and regards

Sravanthi

***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.4.6
Low-Code App Development
User Experience
Data Integration
Other Industry
System Architect
Support Case Parallel

Accepted Solution

Posted: 2 years ago
Updated: 2 years ago
Posted: 18 Jul 2022 6:49 EDT
Updated: 18 Jul 2022 9:10 EDT
Nadimuthu Thangavel (Nadimuthu T)
TATA Consultancy Services
Associate Consultant
TATA Consultancy Services
IN

@sravanthip1652 Apply the conditional format in the excel sheet and upload to binary file. Based on the  condition will apply the color on the cell while download the excel file.

To see attachments, please log in.
Posted: 2 years ago
Posted: 18 Jul 2022 9:10 EDT
sravanthi patnamshetty (sravanthip1652)
Altisource Solutions Inc
Software Engineer
Altisource Solutions Inc
IN

@Nadimuthu T Working Thank you So much.

 

Conditional Format-- > selected Cell -->changed format 

 

Added Attachment also hope this will help others looking for same scenarios

 

Thanks and Regards 

Sravanthi.P

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice