JDeveloper 12c: How to Export data rows to Excel file in 2013 format ? (Doc ID 2112169.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle JDeveloper - Version 12.1.2.0.0 to 12.2.1.0.0 [Release 12c]
Information in this document applies to any platform.

Goal

In JDeveloper12c in an ADF fusion web application, the export of rows to Excel file generates a file compatible with the Excel 1997-2003 format.

For example:

When the file is opened with Excel 2013, it will display a warning message about an invalid format:

"The file you are trying to open 'myfile.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

How can you Export an Excel file in 2013 format? 

Solution

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