Jump to content
JasperReports Library 7.0 is now available ×

Jasper XLS export - Cell value exceeds character limit


Recommended Posts

Cross posted at http://stackoverflow.com/questions/21433647/jasper-xls-export-cell-value-exceeds-character-limit

I export my data using jasper reports to a xls file from java. In one of the cells the data exceeds the character range supported in xls format (32,767).

When I use the below code to fill the report it exports all the data into a single cell.

print = JasperFillManager.fillReport(jasperReport, inputParams, dataSource);

obviously MS Excel and Open Office Calc don't open this file properly.

But when I use the below code it is exported by splitting the data in the column to approximately 3000 characters, and adding it to multiple rows (retaining the same data for other columns and changing this column alone.) not only in xls but in other formats also.

print = JasperFillManager.fillReport(jasperReport, new HashMap(), dataSource);

In the original 'inputParams' map I filled a few details like generated time, page number to be used in report header/footer which will be used in other formats like pdf but not in xls. So this should not be the reason.

I did some search on this, but don't see anybody else reporting this behavior.

Has any one else experienced this behavior? Why is this difference?

What should I do get this same splitting behavior even when I use 'inputParams'?

Version details:

Jasper - 2.0.5

POI - 3.0.1 Java 1.5

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...