how to apply formatting (wrap up on coulumn PFA) on exported excel.
when we run the report there will be the action button to export to pdf or export to excel. when we do export to excel the excel sheet will generate, from that one of the column is very lengthy and I want to wrap that text in generated excel PFA. how I can achive this.?
please help and suggest the approaches.
LTI
IN
Hi,
Can you please give some clarification on the requirement.
Are you running the Report Definition and you are expecting the Wrap in Report definitions run time excel option?
Are you will have a button and on click of it, excel should generate?
Ans: pxGenerateExcelFile is the activity. For this activity, you need to give pass binary file which is your excel with required fields and mapping from the page list appropriately({.pxResults().FieldName}). In that excel you can do all your requirements.
Thanks
Dinesh
Infosys
IN
Hi Dinesh,
Are you running the Report Definition and you are expecting the Wrap in Report definitions run time excel option?
Yes I will run the RD and click on export to excel (pega OOTB) after exporting excel I need wrap on column.
PFA
Thanks,
sadhana
Updated: 27 Jan 2021 12:13 EST
Pegasystems Inc.
IN
I think in 7.3.1, you have an option to opt for old excel formatting(Check pzRDExportWrapper activity) where pega generate the excel based on html code. Then you can have a control to handle the splitting of lines. Refer the control in the column of the report definition.
Saikat