Jasper export to Excel

[k1234]

To create the report xml file we are using iReport tool.

But we are facing problem while exporting report to Excel format.We are getting one field in exponential format. We tried using TO_CHAR in SQL query, but not able to resolve problem.

 

For eg. we have SQL query as follows :

 

select column1 from xyz

 

column1 is containing values in format 11581000029014400

 

but when report is exported to excel, value in cell is shown in exponential format.(Formula bar in excel show 11581000029014400 ).

 

 

 

Kindly provide a solution to remove exponential format, and show value in proper number format in excel report

 

 

 

Thanks in advance,

[k1234]

Hi Everyone,

 

Can anybody give some suggestion on this.. This is a very urgent requirement to my client.

 

Please help in this regard, Any help would be greatly appreciated..

[lknueve]

what is the Expression Class set to? Also, are you using the net.sf.jasperreports.export.xls.detect.cell.type property? if so, what is it set to?

 

[k1234]

Thank you for the response.

 

We have set the Expression class to java.lang.String

 

Its a data base column of type varchar(its a numeric value - Varchar data type in DB) .

 

We have taken String in report for this field, When we export to excel,,its getting converted in to a number and shows in exponential format..

 

Kindly give some inputs..

[lknueve]

in Options/Preferences - > Export Options -> Excel do you have anything set there? Specifically I'm looking at if "Detect Cell Type" is checked - if it is, uncheck it....if it isn't, then can you attach your report so that I can look?