Re: UTL_FILE: Excel

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 10 Jul 2001 14:25:14 -0700
Message-ID: <9ifrrq0h9@drn.newsguy.com>

In article <khJ27.14834$WS4.2363416_at_news6-win.server.ntlworld.com>, "Richard says...
>
>
> Hi
>
> I am using PL/SQL to transfer large amount of data to .csv fil on the
>UTL_FILE. I would like to alter the defalt size of the Excel
>coolumns......can any one help?
>
> Many thanks
>
> Richard
>
>

use the sylk file format, not csv. then you can use headers, formulas, fonts, bold, etc.

See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:728625409049 for the code (search for OWA_SYLK to see other variations of this on that site)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Jul 10 2001 - 16:25:14 CDT