I know that we can use SPOOL command to export query result in CSV format from sql developer. However, I would like to export the query result as xlsx format instead of CSV format. Is there any command that I can use ??
0
votes
2 Answers
0
votes
No.
The best you can do is CSV via spool.
Or, if you're going to be exporting tables/views, you can use the sdcli to batch xlsx exports. I show this in detail here
0
votes
In SQL Developer you can export a gridresult by right-click -> export -> Format = "excel 2003+ ( xlsx ) ... but think you know this already.
Last time I created an XLSX file I used https://technology.amis.nl/wp-content/uploads/2011/02/as_xlsx18.txt
Probably I would use jasper or a different tool now.