E1: GRID: Unable to Export to Excel with More Than 65536 Rows on Excel 2007 or Higher

(Doc ID 1248034.1)

Last updated on NOVEMBER 01, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.


I am using the Excel 2007 version and according to <Document 662069.1>, Excel 2007 can have a maximum Worksheet size of 1,048,576 rows by 16,384 columns. However, I am unable to export more than 65,536 rows of data to Excel.

When trying to export grid data to Excel, Excel does not load. When trying to submit a UBE with Export to CSV option selected, and when Excel tries to open the output, the error "File not loaded completely" is shown in Excel:

The maximum number of rows that I can export is defaulting to the older Excel 97-2003 which only allowed a maximum of 65,536 rows.

If experiencing issues with the data not importing at all, see <Document 1612892.1> E1: GRID: Copy And Paste or Import into Grid Does Not Process or Gives HTTP 500 Error or Exceeding Maximum Parameters with Weblogic or Websphere.



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms