The maximum number of rows permitted on a worksheet been exceeded

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

i changed it to .xlsx but it did it work

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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