How to format excel file and style according to requirement?
I am generating an excel file with pxGenerateExcelFile activity using binary file as template and attaching it to mail. Now I want to format the excel sheet now like changing the colour of heading, background, adding borders and so on. How can I do that? tried making changes in the binary file template with no luck.
***Edited by Moderator Marije to add Capability tags***
Updated: 7 Apr 2022 8:30 EDT
Pegasystems Inc.
GB
@KirtiG48 I was only able to find this video specific to Pega Robotic Automation, not for Pega: How to format a Microsoft Excel spreadsheet
Adept View
NL
Hi @KirtiG48,
i have followed the same steps that you have mentioned. i have updated the excel sheet with necessary styles and run the activity the document is being downloaded as expected.
Please find the document with screenshots.
Wipro
IN
@RaghavenderReddyL I am using pxGenerateExcelFile with a custom binary file, I tried making changes in that binary excel template like changing the background color and all but its not working
Bits in Glass
IN
@KirtiG48Hi Kirti, Making changes in the Binary Excel file should solve the problem.
Even you can achieve different formatting as well by updating the excel file.
Just make sure you are using the correct file.
Wipro
IN
@RakeshBurbure I was trying to add table formatting from home tab which was not working. When I put the background color to entire row, it worked.
Now the filter and sort options are not working. They're working in the template but not in the excel that I am receiving as attachment. Any idea how to resolve that?