Re: Utl_file

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                                                                                         
                    om_at_ica.se            To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>               
                    Sent by:             cc:                                                                               
                    root_at_fatcity.c       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: Roland.Skoldblom_at_ica.se

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: ListGuru_at_fatcity.com (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: Brian_P_MacLean_at_eFunds.Com

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: ListGuru_at_fatcity.com (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).