Unable to Import Certain Excel (xlsx) File With Error Excel Parser Fails to Load Data
Last updated on JANUARY 29, 2016
Applies to:Oracle Agile PLM Framework - Version 220.127.116.11 to 18.104.22.168 [Release 9.3]
Information in this document applies to any platform.
When attempting to import from certain Excel (.xlsx) data source file, with below error occurs:
An error occurred: 62. Excel parser fails to load data from excel file. This may be caused by un-saved excel.
Please try to click SAVE button in Excel and import again.
What is Working
The issue can be reproduced by specific .xlsx file only. Not all .xlsx file has this problem.
After saving the same file in .xls format, error will not occur while import
1. Login to Web Client, and goto Tools > Import
2. Click 'Choose File' button
3. Select the .xlsx file
4. Click 'Next' button
5. Error occurs
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