Hi,
My requirement is to generate an excel from PL/SQL which i was able to do from the the following code from
Sanjeev. 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