Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > J2EE
J2EE General J2EE (Java 2 Enterprise Edition) discussions. Questions not specific to EE will be redirected elsewhere.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the J2EE section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 9th, 2006, 09:06 PM
Registered User
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default iReport Jasper export to Excel

Hi all,

We are trying to use JasperReport from our Java based web application. We are using JDBC Data source. And Report is rendered through a Java Servlet.
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,

Old October 18th, 2007, 03:30 AM
Registered User
Join Date: Oct 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Hi, I have the same problem as you, I think.
In my opinion you should change pattern in properties of this field, but then value could disappear from excel, then you should resize field on the report.
but then value will be detect as string and that is my problem, how to make it not be string and have format for example 11 581 000 029 014 400

p.s. sorry about my English

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting data into Excel using jasper reports raj_plkd J2EE 16 July 13th, 2018 10:58 AM
Reports in excel using jasper mohanasrini J2EE 1 July 1st, 2009 11:15 AM
Jasper Reports Xls export ashtrash J2EE 2 April 6th, 2009 04:45 PM
excel using jasper mohanasrini J2EE 0 March 4th, 2008 08:10 AM
Problem in display all rows using iReport/jasper sohailkhalid J2EE 0 June 5th, 2007 07:42 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.