Export Excel time format issue

[r.reddy.galla]

Hi,

1)I want to export data into excel format there i can see the numbers stored as tesxt format error.

for that i used  "net.sf.jasperreports.export.xls.detect.cell.type" then this issue been resolved.

But now time format is giving error 'd-MMM-yyyy h:mm a' exported as like 7-Jul-2017 10:27 a

it is not giving AM/PM format and simply displaying 'a'

2) percentage pattern error: value like 5.75 in database when i used pattern "#,##0%" this is (value*100) giving 575%

 

Please help us steps if any one these questions that would be greatly appreciated.

Thanks,

Ravi.

[szaharia]

1) set the net.sf.jasperreports.export.xls.pattern property for that element with the value "d-MMM-yyyy h:mm AM/PM"

2) Not sure what is the issue here. 5.75 really means 575% in percents.

If you need to display something like 6% instead of 5.75, you could place $F{myDatabaseField}/100.0 in your textfield instead of $F{myDatabaseField}, and use the "#,##0%" pattern

[r.reddy.galla]

Hi Shertage,

Thanks for your help it is working fine and so useful for me.

thanks lot once again...