I'm using 184.108.40.206. The newer versions of Excel support more then 65535 rows but ADF will not export more than this amount. Has this been fixed in 220.127.116.11 version? Any examples on how to accomplish this apart from Apache POI?
(is it just me or is the forum having really long page load times today)
I found that ADF has a hard coded size limit in
In oracle.adfinternal.view.faces.export.TableExporter class
This is the code
// Maximum number of records in Excel. As far as we know this is the upper
// limit that Excel can handle. In the future we might make this value
private static final int _EXCEL_MAX_RECORDS = 64*1024;
private void _renderAllDataRows(FacesContext context,
int rowCount = collectionObject.getRowCount();
if (rowCount == 0)
int maxCount = _EXCEL_MAX_RECORDS - (colData.getHeaderless() ? 0 : colData.getLayerCount());
for (int r=0; !(rowCount > 0 && r >= rowCount) && r < maxCount; r++)
_renderDataRow(context, rw, columns, collectionObject, detailStamp);
Message was edited by: DonKleppinger
User, as you already have an application it should be easy to try it out yourself and learn something about using 18.104.22.168.0
They are working on the forum software to solve some problems. Sometimes we see that the forum doesn't perform like it should. Just wait and it will be better after some time.
Message was edited by: Timo Hahn Don, just checked the source of 22.214.171.124.0 and the code looks the same. The constant is still 64*1024 so the limitation is still there
Message was edited by: TimoHahn The editor is doing some strange stuff today. Somehow the spelling was changed. More work to do for Oracle.
I was able to verify it could be possible by setting a breakpoint in the code shown above and then modifying the maxCount variable in the debugger to 85000 and it successfully exported 85000 rows to excel. Since this is a private final integer there is no way to change it at runtime though..