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

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
;)

Thank you very much Vikas.My email ID bsuroop@rediffmail.com.Pls send me the utility.

Kishan

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

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

http://www.dbasupport.com/oracle/ora...cting4_1.shtml

Just dump it into Excel and format it from there.