af:exportCollectionActionListener With Type ExcelHTML File Format Gives Error "The file format and extension of 'xxxx.xls' don't match." In Microsoft Excel 2013

(Doc ID 2377886.1)

Last updated on MARCH 30, 2018

Applies to:

Oracle JDeveloper - Version 11.1.1.9.0 to 11.1.1.9.0 [Release Oracle11g]
Information in this document applies to any platform.

Goal

When opening a exported file that was exported using af:exportCollectionActionListener and using type excelHTML, with Microsoft Excel 2013, the following error is reported:-
"The file format and extension of 'export.xls' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it.Do you want to open it anyway?"

The af:exportCollectionActionListener is connected with a af:table for the data using the exportedId attribute.
This behavior is browser independed and seen in all browsers.
Is there a correct configuration for the af:exportCollectionActionListener to avoid this error ?
 

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