Home » SQL & PL/SQL » SQL & PL/SQL » Formatting excel generated from PL/SQL
Formatting excel generated from PL/SQL [message #435535] Wed, 16 December 2009 10:24 Go to next message
muralidharan_s05
Messages: 1
Registered: December 2009
Location: India
Junior Member
Hi,

My requirement is to generate an excel from PL/SQL which i was able to do from the the following code from Sanjeev ( http://sanjeev-oracle-world.blogspot.com/2007/06/create-excel-workbook-by-plsql-code.html). I was able to generate an excel but the data in the cells were all in formatted as 'general' i want date to formatted as 'date' and currency as 'currency'.

I searched further and landed upon the following piece of code
<Cell><Data ss:Type="DateTime">1928-06-25T00:00:00.000</Data></Cell>
but even it was not helpful.

Can anyone help me with this? Can this be achieved?

Thanks,
Murali

P.S:I am unable to post the link because the forum did not allow me to and it gave me the following message- You cannot use links until you have posted more than 5 messages.

[Updated on: Wed, 16 December 2009 10:30] by Moderator

Report message to a moderator

Re: Formatting excel generated from PL/SQL [message #435556 is a reply to message #435535] Wed, 16 December 2009 15:37 Go to previous message
coleing
Messages: 213
Registered: February 2008
Senior Member
This one has that capability....

http://matzberger.de/oracle/spreadsheet-en.html
Previous Topic: How many rows are processed in this Query ?
Next Topic: Check if current procedure/function is running
Goto Forum:
  


Current Time: Sat Dec 03 08:16:58 CST 2016

Total time taken to generate the page: 0.12224 seconds