-
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
-
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
-
Thank you very much Vikas.My email ID bsuroop@rediffmail.com.Pls send me the utility.
Kishan
SUROOP B
-
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
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|