You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tFileOutputExcel:maximum number of rows has been exceeded
#1 2008-08-28 14:50:51
- jollyjohn
- Member
- Registered: 2008-07-03
- Posts: 32
tFileOutputExcel:maximum number of rows has been exceeded
Hello,
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
at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1070)
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1046)
at procedure_bouclage_bavar.requete_05.requete_05.tOracleInput_1Process(requete_05.java:457)
at procedure_bouclage_bavar.requete_05.requete_05.runJobInTOS(requete_05.java:680)
at procedure_bouclage_bavar.requete_05.requete_05.main(requete_05.java:596)
How can I solve this problem?
Regards, Jollyjohn
Last edited by jollyjohn (2008-08-28 14:51:08)
Offline
#2 2008-08-28 14:56:29
- jcoutin
- Member
- Registered: 2008-05-30
- Posts: 170
Re: tFileOutputExcel:maximum number of rows has been exceeded
Hello,
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.
JC
Last edited by jcoutin (2008-08-28 15:03:52)
Offline
#3 2009-02-18 00:27:40
- simony
- Guest
Re: tFileOutputExcel:maximum number of rows has been exceeded
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?
#5 2013-03-07 13:43:57
- lubod
- Member
- Company: Deak Computer Services
- Registered: 2010-12-13
- Posts: 25
Re: tFileOutputExcel:maximum number of rows has been exceeded
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.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tFileOutputExcel:maximum number of rows has been exceeded