Question
AGF Investments Inc
CA
Last activity: 15 Jan 2025 1:05 EST
How to generate an excel file (.xlsx) using D_pxNewFile in pega activity
We have a requirement to create an excel file containing the results of a report definition. This excel file needs to be placed in the pega cloud repository.
While we tried to use the D_pxNewFile, we only get empty files. How to populate the contents for an excel?
Pegasystems Inc.
US
@SowmyaR3732 Please refer to https://support.pega.com/discussion/how-use-repository-api
"This API creates (uploads) a file in a repository. You need to prepare a file contents before calling API. You can either pass file contents to API either by String (pyContents) or Stream (pyStream). Unlike Get file API, there is no explicit parameter that differentiates these and whichever property is populated will be used. If both properties are populated, String will take precedence."
AGF Investments Inc
CA
@Aditya Sethia Thank you. I found an Url that gives an example to save the file in CSV format. The same doesn't work for xlsx.
https://support.pega.com/discussion/how-replace-connect-file-implementation-repository-api-approach
AGF Investments Inc
CA
Do we have any samples for the xlsx in this case?
Accenture
SG
Did you managed to achieve the requirement " create an excel file containing the results of a report definition. This excel file needs to be placed in the pega cloud repository"
If yes, Kidnly share the steps you followed to achieve it.
Thank you.
Bits in Glass
IN
1. You can generate csv file from RD list using pxConvertresultstocsv...
2. Then pass pycontent Or attachstream to D_pxNewFile to move that file to repository.
Bits in Glass
IN
1. You can generate csv file from RD list using pxConvertresultstocsv...
2. Then pass pycontent Or attachstream to D_pxNewFile to move that file to repository.