Skip to Main Content

Java Development Tools

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!

Excel Export not working in ADF 12.2.1.4

User_A0MNWMar 23 2022 — edited Mar 23 2022

Hi,
I have a problem in ADF 12.2.1.4. I have a table inside a panel collection and I have menu's in which try to export the table data to excel. (Used for this af:exportCollectionActionListener ) However this is not working for me. I get the following error when I open the Excel .

Column Headers in the Excel show up and then the following below : Export is incomplete due to error Cannot format given Object as a Date.
excel-issue-png.pngIn jsff page ; Date columns like that in table, it is an outputText.

<af:column sortProperty="Sdate" sortable="false"
headerText="#{bindings.Survey.hints.Sdate.label}"
id="c2" width="145">
<af:outputText value="#{row.Sdate}" id="ot1">
<af:convertDateTime pattern="#{bindings.Survey.hints.Sdate.format}"/>
</af:outputText>
</af:column>

IN VO level it 'a date attribute, and in UI Hints tab Format Type :Simple Date and Format : yyyy/MM/dd-HH:mm:ss

ss.PNG
It was working fine in the previous version ADF 12.2.1.1. Is there such a problem with this version 12.2.1.4 ? Can anyone help with what the solution is?

Thanks.

This post has been answered by dvohra21 on Mar 23 2022
Jump to Answer
Comments
Post Details
Added on Mar 23 2022
2 comments
921 views