Export to Excel only exports the first 300 rows in Clarity
book
Article ID: 29842
calendar_today
Updated On: 01-08-2025
Products
Clarity PPM On Premise
Issue/Introduction
- When using the feature "Export to Excel" in Clarity PPM to export project or other data, only the first 300 rows are returned in the exported file
- Is the Excel Icon on the page able to be modified to allow for more than just 300 rows to be exported?
- This is seen from NSQL based portlets or other types of portlets / lists with this data
- Same issue is seen when trying to export slides / PowerPoint
Environment
Release: All Supported Releases
Component: Clarity PPM Studio
Cause
- This limit can't be changed or disabled.
- The intention of the option for 'Export to Excel' or 'Export to PowerPoint' is to provide a nicely formatted output.
- Therefore, a restriction on the number of rows to be exported into this format is implemented.
Resolution
1. Use "Export to Excel (Data Only)" instead, as it does not have a 300 row limit.
- This option allows the user to export the numerical data into a spreadsheet and then it can be formatted to export 25,000 records.
2. The other option would be to export 299 records at a time using Export to Excel.
Feedback
thumb_up
Yes
thumb_down
No