How do I export Oracle table data into Excel with Formatting?
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.
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 : firstname.lastname@example.org ; email@example.com
It is the mark of an educated mind to be able to entertain a thought without accepting it.
Thank you very much Vikas.My email ID firstname.lastname@example.org.Pls send me the utility.
I am bothering about this problem recently.Can you share your program with me?Thank you very much!
My email: email@example.com
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.
Click Here to Expand Forum to Full Width