When Opening an Excel File Created by ADF component af:exportCollectionActionListener Following Warning is Occurring: "The File Format Differs From The Format That The File Name Extension Specifies"

(Doc ID 1944927.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle JDeveloper - Version and later
Information in this document applies to any platform.
MS Excel 2007 and later versions


When using an af:exportCollectionActionListener component to export af:table data to Excel following warning can be raised:

"The file you are trying to open, '<filename.xls>', is in 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 to disable the above warning?


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