var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Writting to Excel file
I want to read data from oracle 8i table, using a cursor and store the same DIRECTLY into an excel worksheet.
Any one can help me ?
Sounds like a question you should be asking on an Excel forum, not an Oracle one. Does Excel provide an API for writing worksheets? (I don't know).
What I do is write to a simple flat file in CSV format, which Excel can load very easily.
Thanks for your suggession.
I got some information about OWA_SYLK UTL_FILE, which can be used to send oracle data into excel sheet.
Could any one put a focus on OWA_SYLK UTL_FILE ?
Last edited by jayanta_deb; 10-05-04 at
the necessary package can be downloaded from
& for me it works for a special purpose, but I still prefer Andrew's advice
You could also just concatinate the columns with a comma or tab and spool to a comma / tab delimited file ...
sql> spool c:\1.txt
sql> select username||chr(9)||sid||chr(9)||serial#||chr(9)||pr ogram from v$session;
sql> spool off
sql> select username||','||sid||','||serial#||','||program from v$session;
Excel has what is call the Microsoft Query wizard, which you can use to Query almost any DB (as long as you have the drivers for it), Microsoft built a Oracle ODBC driver with excel which you can use. Look for this under the Menu 'Data->External Data'.