E1: GRID: Export To Excel Receives Warning - "The file format and extension of 'Book1.xls' don't match. The file could be corrupted or unsafe..." (Doc ID 2694979.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

When performing grid export using the option "Export to Excel" chosen in Export Assistant, when opening the file, receives the following warning message:

"The file format and extension of 'Book1.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 file is created with an extension of .xls. Is there a way for the file to be created with an extension of .xlsx instead?

Secondly, if user tries to do a Save As.. in Excel to save the exported file, it defaults to a XML format. How to save the exported file in native Excel format?

  

Note: ActiveX control is disabled (SupportActiveXIE=False or OLEONLY)
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.