Formatting excel generated from PL/SQL

741485

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

Marwim

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

riedelme

Would a simple CSV output file do the job?

If so just concatenate your output together using commas, somthing like

select column1||','||column2||','||column3
  from my_table

saving the results to a file

Marwim

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

741485

Hey,

Thanks for your reply. But it still does not solve my issue, I want the cell to be formatted as data/currency. I am able to format the value in the cell.

Thanks,
Murali

741485

Thanks a lot Marcus. I got my answers.

~Murali