My Oracle Support Banner

"ERROR: Failed to find sheet or range named TASK in the xlsx file" When Importing an XLSX File (Doc ID 3024101.1)

Last updated on MAY 22, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 22.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to import an XLSX file, the process does not complete successfully and the following error(s) are found in the import log file.
  

ERROR

ERROR: Failed to find sheet or range named TASK in the xlsx file
ERROR: Failed to find sheet or range named TASKRSRC in the xlsx file


The issue can be reproduced at will with the following steps:

  1. Log-on to P6 Pro.
  2. Open a project.
  3. Go to File > Import.
  4. Use the Import Wizard to import a Spreadsheet - (XLSX) file.
  5. Receive error.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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