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:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
For Tools Releases prior to 188.8.131.52
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document