SPOOL data from Oracle to workbook

Question

I have prepared SQL*Plus script, part of it is SPOOLof a tables to .csv files, so I started wondering if it's possible to create the excel workbook and add those to it using SQL?

I have tried SPOOL to .xlsx with set sqlformat csv but when i try to open it, it returns an error.

Thanks for the feedback

sqlcl doesn't spool to xls/xlsx. CSV creates a file with csv data. — Kris Rice, May 18 '18 at 10:19

score 0 · Answer 1 · answered May 18 '18 at 08:42

0

https://stackoverflow.com/a/49530512/5860789

Follow above answer of mine and use ".csv" format instead of ".txt"

answered May 18 '18 at 08:42

Paras

240
1
13

Spool into .csv works fine for me, I've been wondering if i can take it further, and append it to workbook using SQL – Doniu May 18 '18 at 08:44

SPOOL data from Oracle to workbook

1 Answers1