3 Replies Latest reply: Jun 21, 2013 7:52 PM by Don Kleppinger RSS

    ADF Table / View Export to Excel size limit is 65536 rows

    Don Kleppinger

      I'm using 11.1.1.4.   The newer versions of Excel support more then 65535 rows but ADF will not export more than this amount.   Has this been fixed in 11.1.1.7 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

        // configurable...

        private static final int _EXCEL_MAX_RECORDS = 64*1024;

       

        private void _renderAllDataRows(FacesContext context,

                                        ResponseWriter rw,

                                        ColumnHeaderData colData,

                                        List<ColumnHeaderData.LeafCellInfo> columns,

                                        RowKeyIndex collectionObject,

      UIComponent detailStamp)

      throws IOException

        {

      int rowCount = collectionObject.getRowCount();

      if (rowCount == 0)

      return;

       

      int maxCount = _EXCEL_MAX_RECORDS - (colData.getHeaderless() ? 0 : colData.getLayerCount());

      for (int r=0; !(rowCount > 0 && r >= rowCount) && r < maxCount; r++)

      {

      collectionObject.setRowIndex(r);

      _renderDataRow(context, rw, columns, collectionObject, detailStamp);

      }

        }

       

      Message was edited by: DonKleppinger