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 11.1.1.0.0 and later
Information in this document applies to any platform.
MS Excel 2007 and later versions

Goal

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?
 

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