Support Article
Unable to generate Excel file using pxGenerateExcelFile
SA-98793
Summary
Unable to generate an Excel file using the pxGenerateExcelFile despite using the same templates as used in the MSOGenerateExcelFile. The user can generate the Excel file using the MSOGenerateExcelFile.
Error Messages
Not Applicable
Steps to Reproduce
- Create a Binary file for Excel template.
- Invoke the pxGenerateExcelFile activity from the click of a button or the Post processing with download checkbox selected.
- Execute the Activity.
Root Cause
Templates with images and a large number of columns were used.
The new pxGenerateExcelFile activity only accepted files which had two rows, the Header row and the property Reference row. The new activity was created to focus more on data and processing than the Excel file structure.
Resolution
Perform the following local-change:
Use MSOGenerateExcelFile when custom templates with multiple rows are used.
However, it is recommended to modify the template and use the pxGenerateExcelFile.
Published January 29, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.