Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Configure the list view and enable Export to Excel option.
  2. 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.
  3. 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.



Suggest Edit

Published February 1, 2018 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us