Support Article
Unable to open an Excel Report with xlsx format
SA-44595
Summary
Error when opening an Excel Report of xlsx format.
Error Messages
Excel cannot open the file ‘XXXX.xlsx’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Steps to Reproduce
- Configure the list view and enable Export to Excel option.
- Run the agent. The agent runs the list view (use Excel format of xlsx) and exports the data to Excel. It also sends a mail of the generated Excel report.
- Open the Excel file.
Root Cause
PRPC 6.2 SP2 does not support the xlsx format.
Resolution
When using PRPC 6.2 SP2, xls format must be used while exporting to Excel.
The xlsx format is supported from Pega 7.3.
Published February 1, 2018 - 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.