How to set Excel cell format in iReport

export-to-excel ireport cell-formatting
blow picture blow · Jul 24, 2011 · Viewed 16.6k times · Source

I'm trying to export a report as xls, but when i open my exported file i notice that all cell formats are Number and all data are wrote with ' like text data (integer fields and double fields also...) so i cant apply any formula like SUM in Excel.

How can i keep cell format in according to my iReport TextField class expression?

I'm using iReport 4.0.2.

Thanks to all.

Answer

speci picture speci · Oct 17, 2011

i've been looking for the same problem and found the following:

http://jasperreports.sourceforge.net/sample.reference/xlsformula/index.html

you can set up the "detect cell type" to default true under export excel settings in ireport.

regards

Related questions

JasperReports: How to format numeric data with Excel exporter

I'm using iReport 2.0.2. I have a problem with formatting numeric data after generating report with help of Excel exporter. For example, the 85110057689 string is showing as 8.51100e+10 in Excel file (as result of using "preview in Excel" button in iReport). …

Read More
How to show each subreport in a separate Excel sheet

I would like to create a report with iReport for MS Excel. My report includes two subreports. I need each subreport in a separate Excel sheet, but the generated export file has all data in one sheet. I don't know …

Read More
Export SQL query data to Excel

I have a query that returns a very large data set. I cannot copy and paste it into Excel which I usually do. I have been doing some research on how to export directly to an Excel sheet. I am …

Read More