Jasper Ireport exports empty excel file when setting detect cell type

[roma.jadhwani]

When i Preview my report in Excel using iReport Designer 5.0.1, my values are considered as text instead of numeric.After setting property detect cell type to true at report level, I am getting empty .xls file

 

[ajinkya_c]

Hi Roma,

Have you checked field datatypes in ireport.

May be field having string datatype or you can try with same report export from jasperserver and then check.

Thanks,

Ajinkya

 

[roma.jadhwani]

Hi Ajinkya,

Thanks for the reply.

[roma.jadhwani]

 

The datatype is set to java.math.bigdecimal and we are calling JasperReport APIs in java to download the report in excel,we are not using JasperServer.

In iReport Designer, when I set the following property - in properties expression for that textfield,I am able to generate XLS file with values being considered as numeric which is correct.

But for some of the reports when I preview in XLS i am getting empty file.

[roma.jadhwani]

The datatype is set to java.math.bigdecimal and we are calling JasperReport APIs in java to download the report in excel,we are not using JasperServer.
In iReport Designer, when I set the following property - <property name="net.sf.jasperreports.export.xlsx.detect.cell.type" value="true"/> in properties expression for that textfield,I am able to generate XLS file with values being considered as numeric which is correct.
But for some of the reports when I preview in XLS i am getting empty file.

[ajinkya_c]

Hi,

If your field contains any null records then replace it with 0 through field expression then check wth excel export.

It may be an issue.

Thanks,

Ajinkya

[saranya232901]

Hi,

I too have same kind of issue in iPad. I am getting emply .xlsx file when i set detect cell type to true. If i set detect cell type to false, then only data in few columns are displayed though there are data for other columns.

I am generating the report via JasperReports. Previewing the report in iReport works fine.

This issue is only in iPad Safari. The report is generated with data in all other browsers in Windows OS.

Can anyone help!!

Thanks in advance!!