SQL*Plus SPOOL File Output with .XLSX Extension Fails to Open in Excel
(Doc ID 2423612.1)
Last updated on JULY 16, 2018
Applies to:SQL*Plus - Version 220.127.116.11 and later
Information in this document applies to any platform.
Use SQL*Plus SPOOL command to generate an .xlsx output file. When attempt to open this output file in MS Excel, it fails with the following error message:
The issue can be reproduced at will when execute the following sample script in SQL*Plus:
Then attempt to open /tmp/spooled_output.xlsx in MS Excel.
It will fail with the reported error above.
Generating .xlsx output files.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!