The maximum number of rows permitted on a worksheet been exceeded

One Star

The maximum number of rows permitted on a worksheet been exceeded

i'm trying to insert a large number of data into an excel file but i get thos error:
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:1214)
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)
at consolidation.myetl_0_1.Myetl.tFileList_1Process(Myetl.java:2410)
at consolidation.myetl_0_1.Myetl.runJobInTOS(Myetl.java:4403)
at consolidation.myetl_0_1.Myetl.main(Myetl.java:4265)
my source excel file has a datasource like for example every field is a combobox with some values from the datasource.
and when i try to load the destination file i got the error above.
how can i increase the maximum number of rows?
Four Stars

Re: The maximum number of rows permitted on a worksheet been exceeded

You can think of using .xlsx as output file...
Vaibhav
One Star

Re: The maximum number of rows permitted on a worksheet been exceeded

i changed it to .xlsx but it did it work
Four Stars

Re: The maximum number of rows permitted on a worksheet been exceeded

There is a check box to enable writing to .xlsx, whether it is enabled?
Vaibhav
One Star

Re: The maximum number of rows permitted on a worksheet been exceeded

there are some combobox that get value from the datasource
my problem is the destination excel file takes into consideration the datasource of the file
Four Stars

Re: The maximum number of rows permitted on a worksheet been exceeded

Are you getting same error now?
Can you show the screenshot or of your combobox?
Vaibhav