Forum Stats

  • 3,854,955 Users
  • 2,264,441 Discussions
  • 7,905,846 Comments

Discussions

Formatting excel generated from PL/SQL

741485
741485 Member Posts: 3
edited Dec 17, 2009 10:20AM in SQL & PL/SQL
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
Tagged:

Best Answer

  • Marwim
    Marwim Member Posts: 3,653 Gold Trophy
    Answer ✓
    Hello Murali,

    I don't know whether Sanjeevs package allows custom formatting of cells, but you can use others like
    https://xml-spreadsheet.samplecode.oracle.com/ or
    https://exceldocumenttype.samplecode.oracle.com/

    Regards
    Marcus

Answers

This discussion has been closed.