You are not logged in.
i have a job with a request in entry and in output I have an excel file but when I run the job I have this message :
Exception in component tFileOutputExcel_1
jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
How can I solve this problem?
Last edited by jollyjohn (2008-08-28 14:51:08)
An Excel worksheet is limited in number of row (about 65k)
So I think you try to put more than 65k rows in your excel file.
Last edited by jcoutin (2008-08-28 15:03:52)
I came across this error with JasperOutput writing XLS file but I only have 45k records
The interesting thing is if I use the FileOutputExcel component, there's no error and successfully finished the export.
So I copied jxl.jar from FileOutputExcel and put it under JasperOutput dir, then reference the new jar file in tJasperOutput_java.xml.. still giving me that number of rows exceeded exception...
Any other ways to fix it?
any update on this?
Did you try to use the checkbox "Write excel2007 format" ?
The 65K limitation should be for older versions and the new format should support over 1 million records per sheet.
If you still have more records than the Excel limit you should split the data between multiple sheets or multiple Files.