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
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
How can I export tables to Excel from a webpage

How can I export tables to Excel from a webpage. I want the export to contain all the formatting and colours.

Read More