Translate

Tuesday 18 August 2015

How to resolve can't add a cell error - While Exporting to excel in Jasperserver

This is an error which you get while exporting the data from the Jasperserver in the Excel Format.

Something of this sort






For resolving this you should check some of these errors:

1. Number to string cast exception:
This means that a number is wrongly appended to a string in which wrongly cast number into string.
In order to fix this, you will have to use the command as

new DecimalFormat("##,#0.00").format(number).toString()
This will cast your number into two decimal places with the thousand separator.


2. Another error that can be checked is of any other cast errors, or formatting of the data in the report.


Cheers!!


2 comments:

  1. Hey Ankur,

    Can I edit(customize) cell size in table in jaspersoft ireport designer?

    ReplyDelete
  2. The content of your blog is exactly what I needed, I like your blog,
    I sincerely hope that your blog a rapid increase in traffic density,
    which help promote your blog and we hope that your blog is being updated.
    wordpress
    blogspot
    youtube
    ប្រដាល់

    ReplyDelete

Please post your queries or suggestions here!!