This content has been marked as final. Show 1 reply
Spool will create a text file, so while your file will be created with the XLS file extension, it's just going to be a flat text file. If you want an Excel file, you'll need to use the SQL Developer Grid, Export -> Excel feature. I believe there are some folks that have built db packages that can create xls files, so you could try looking for those if you wanna stay in the script/SQLPlus world.
Also, your version is very out of date. Can you upgrade to v3.2 and try again?