oracle.xdo.servlet.data.dataexception: your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation

Hi Everyone,

 oracle.xdo.servlet.data.dataexception:oracle.xdo.servlet.data.dataexception:oracle.xdo.XDORuntimeException: your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop Processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties

If you see this issue while generating Excel output in BIP Report, it is due to the reason that you have large amount of data in your report. In an Excel sheet, it can accommodate only upto 65531 records, if more that count of data comes this issue arises.

Solution to this problem:

Go to the concerned Report and open properties

Formatting

Excel Templates > Enable Scalable Mode. Set this to True

Now go and check if report is working for large data. If you check the report output, we can see data comes in multiple sheets.