Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to Excel – XLS file formatting

Przemysław StaniszewskiNov 14 2008 — edited Nov 14 2008
Hi,

I have created process that exports report to XLS file. I write XLS file using XML tags, supported by Excel, which allow me to format each cell (especially look and data type). Unfortunately I can’t force Excel to see cell as date-cell.
I’m getting from database date in YYYY-MM-DD format and I want the same in Excel. I can export it as string value, but I want Excel to see it as date – not string.

This code works fine:

<ss:Cell><ss:Data ss:Type="String">'||x.begin_date||'</ss:Data></ss:Cell>

but Excel see the cell as a string.
I want something like that:

<ss:Cell><ss:Data ss:Type="Date">'||x.prnm_short_name||'</ss:Data></ss:Cell>

but this one doesn’t work, as well as “DateTime” type.

Do you know how to solve this problem?

Regards,
Przemek

Edited by: Przemek on 2008-11-14 13:11
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2008
Added on Nov 14 2008
2 comments
1,361 views