I don't think you will be able to do what you want with utl_file unless you
know the entire Excel file formatting details. I don't think BOLDING,
RIGHT JUSTIFY, etc. can be part of a .cvs file.
I know that Oracle has several products or options for $$$ that can do a
lot of the Excel formation things for you. I have never had to deal
directly with them and I am not even sure of all the available solutions.
But in an effort to point you in the correct direction (maybe) look into
"Objects for OLE", "Web DB", and "Oracle Reports". There is no simple
solution and you are going to need to do some research.
Overall, I think is more pain than it's worth for just some fancy
formatting (tell them to highlight and justify it themselves).
Another option might be to put it in html table format, easy with utl_file,
and then open/import that into Excel (just an idea)
I tried to help, if all this is wrong, then just remember that it was for
free;-)
Brian P. MacLean
Oracle DBA, OCP8i
Roland.Skoldbl
[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Utl_file
om
04/11/02 05:28
AM
Please respond
to ORACLE-L
Hallo,
Is it possible to do a select from some tables in the database and then use
utl_file package to create an excel file. And also to make the headers in
the columns bold and right positioned. Please give me an easy example on
how to write the code.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
