Missing leading zero for zipcode in Excel

[HBK32]

Hello,

 

I am generating report which gives output in Excel sheet.In that it is missing leading zero when zipcode starts with zero BUT in the PDF it is coming correctly NOT in Excel sheet.Why?

 

Data type for zipcode is String.

 

Now anyone has an idea how to print zipcode with leading zero in Excel sheet???

 

Thanks in advance,

Badrish.

[lucianc]

Set the JRXlsAbstractExporterParameter.IS_AUTO_DETECT_CELL_TYPE exporter parameter to Boolean.FALSE when you export the report to Excel.

 

HTH,

Lucian