12.2.2 : Import From Excel To Worksheet Error: Import file format is incompatible with Worksheet
Last updated on APRIL 02, 2018
Applies to:Oracle Demantra Demand Management - Version 12.2.2 and later
Information in this document applies to any platform.
Customer has upgraded from 731 to 12.2.2
The export and import functionality is not working
Customer has Windows 7 and when he tries to export a worksheet he gets the message
The file you are trying to open, 'Export.xls', is in a 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?
Customer clicks Yes
The customer is able to open the excel file, make updates/overrides to some series, save the file. They get the following message when they try to save it
Export.xls may contain features that are not compatible with Unicode text. Do you want to keep the workbook in this format?
To keep this format, which leaves out any compatible features, click yes
To preserve the features, click no. The save a copy in the latest excel format
To see what might be lost, click Help
Click Yes to save the file
Then Go to worksheet and try to import the file
Get the following
The import file format is compatible with the worksheet. Please review the file headers to ensure they map the worksheet structure (Levels, Time and Series) and reload
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