Unable to Import Certain Excel (xlsx) File With Error Excel Parser Fails to Load Data (Doc ID 1957582.1)

Last updated on JANUARY 29, 2016

Applies to:

Oracle Agile PLM Framework - Version 9.3.1.2 to 9.3.4.0 [Release 9.3]
Information in this document applies to any platform.

Symptoms

When attempting to import from certain Excel (.xlsx) data source file, with below error occurs:

Error
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

Steps

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

Cause

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