Archive for the ‘spool to excel’ tag
Spool to a .xls (excel) file…
A small tip, I read on OTN about spooling to a .xls (excel) file:
It goes like this
set feed off markup html on spool onspool c:\salgrade.xls select * from salgrade; spool offset markup html off spool off
And the xls it makes shows up like:
Sidhu