Question
AGF Investments Inc
CA
Last activity: 31 Jul 2024 14:33 EDT
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
@AdityaSethia 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?