MSOGenerateExcelFile deprecated in Pega Infinity any example using pxGenerateExcelFile?
Hello,
We had couple of activities using MSOGenerateExcelFile and we had to modify one of them after moving to 8.2
We found that MSOGenerateExcelFile is now deprecated and we are supposed to use pxGenerateExcelFile.
Since both function have almost same parameter we tried to switch to the new version but it failed with the following message.
The uploaded file template could not be recognized. Please upload a valid file. Refer to template for details.
Same activity work perfectly with MSOGenerateExcelFile.
I'm unable to find any activity using pxGenerateExcelFile to see how it work and in the other end I find a lot still using MSOGenerateExcelFile (In agile studio 8.2 for example it's still widely used)
Is there any working example we can see on how it should be used?
Thank you
Pegasystems Inc.
IN
Hi,
Please refer the below link which has an example showing the use of pxGenerateExcelFile.
https://collaborate.pega.com/discussion/export-data-data-page-excel
Kindly verify the steps with the your implementation and check if you have done something different.
If you still face the issue create a new template file and use it and then try the use case.
Regards,
Vikash
Bluevoir
IN
Hi @LoicM950,
The new activity pxGenerateExcelFile only accepts two rows where one is the header and the other is the property reference.
If you have any additional rows then this errors are Expected. PxGenerateExcelFile is created for efficient performance.
If you have any other rows then you can use MSOGenerateExcelFile even though it is deprecated it doesn't impact the functionality. But using a modified template and the new pxGenerateExcelFile actiivty is recommended.
Regards,
Hoyath