My Oracle Support Banner

E-QR: Query Manager - Export To Excel Downloads Output Files As *.xls Instead of *.xlsx (Doc ID 2919080.1)

Last updated on JANUARY 03, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On running any Query to Excel from Query Manager in PIA the Excel file gets downloaded as *.xls instead of *.xlsx .
The Query Manager exports query results in older version of Excel.

It should download as *.xlsx even if there are less than 65,000 rows in Query result.

Steps to replicate:

1. Login to PIA and navigate to Reporting Tools-> Query -> Query Manager.
2. Select and run any Query to Excel output.
3. The results get downloaded in .xls file and not in .xlsx file.

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
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.