How do I export Oracle table data into Excel with Formatting?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How do I export Oracle table data into Excel with Formatting?

  1. #1
    Join Date
    Mar 2002
    Posts
    38

    How do I export Oracle table data into Excel with Formatting?

    Hi Friends,
    I want to export the employees table records into excel spreadsheets with formatting. For instance, I need to get all the column names and also data correctly fitted into the cells of the excel file.For this I am using the spool technique and also the UTL package, but I am not able to get the formatted output. Pls give your suggestions.

    Thank You,

    Kishan
    SUROOP B

  2. #2
    Join Date
    Jun 2004
    Location
    Ludhiana (Pb.) INDIA
    Posts
    12

    Thumbs up

    Hi Kishan,

    I have my own built utility that can help u 2 export any table data into excel. gimme ur email id i can send the file to u. just make the required changes and execute it. it is a d2k form file.

    my mail id is : vikas_ver@hotmail.com ; verma_vicky@yahoo.com

    Cheers
    Vikas Verma
    Vikas Verma
    ___________
    It is the mark of an educated mind to be able to entertain a thought without accepting it.
    __________
    Aristotle

  3. #3
    Join Date
    Mar 2002
    Posts
    38
    Thank you very much Vikas.My email ID bsuroop@rediffmail.com.Pls send me the utility.

    Kishan
    SUROOP B

  4. #4
    Join Date
    Mar 2004
    Posts
    8
    hi!Vikas Verma
    I am bothering about this problem recently.Can you share your program with me?Thank you very much!
    My email: hzadonis@hotmail.com

  5. #5
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350

    Another (free) option ...

    Just to add : IF you are using Oracle 8i or better, with sql*plus 8.1.7 or higher, you ALREADY have a way : use the SET MARKUP HTML command in sql*plus, generating a .HTML file, and open it in Excell : the columns WILL be cells in Excell, and Excell WILL recognize any html "beatifiers" included, like font, size, colors, etc. Search the old messages in this Forum to find examples and hints.

    Regards,

    Chiappa

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    http://www.dbasupport.com/oracle/ora...cting4_1.shtml

    Just dump it into Excel and format it from there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width