Backoffice Excel Export Date Format

[former_member753926]

Hi Experts,

I want to use customized date format while exporting the data from backoffice through export excel.

By default OOTB provides ExcelJavaTypeTranslator translator which is providing date format as "dd.MM.yyyy HH:mm:ss" in ExcelDateUtils.

I am extending ExcelJavaTypeTranslator translator and overriding the methods with custom logic where i made date format as "MM/dd/yyyy HH:mm:ss"

*-spring.xml:

<cng:list-extender bean="excelTranslatorRegistry" property="translators">
   <cng:add>
      <ref bean="medExcelRetailerDateTranslator"/> 
   </cng:add>
</cng:list-extender>

<alias name="medExcelRetailerDateTranslator" alias="medExcelRetailerDateTranslator"/>
<bean id="medExcelRetailerDateTranslator" parent="excelJavaTypeTranslator">
</bean> 

But everytime while exporting the data in excel its creating the date format as "dd.MM.yyyy HH:mm:ss".

Is there anything that needs to be configured?

Any help would be appreciated?

[miriamschroettner]

I solved a smiliar issue with a own ExcelDateUtils and setting the dateTimeFormat in the constructor and it worked.