Excel number of rows greater then 65k support

[GoogleCodeExporter]

Is the possible to add support of excel export with more than 65k rows to avoid 
such an exception? 

I think the current solution works with older version of Excel where only 65k 
rows is supported. Would it be possible to support later formats as well?

BUILD FAILED
c:\Development\DOCS\Siemens\SWE\translation\i18nBinder_0.1.12\build.xml:32: 
java.lang.IllegalArgumentException: Invalid row number (65536) outside all
ge (0..65535)
        at org.apache.poi.hssf.usermodel.HSSFRow.setRowNum(HSSFRow.java:232)
        at org.apache.poi.hssf.usermodel.HSSFRow.<init>(HSSFRow.java:86)
        at org.apache.poi.hssf.usermodel.HSSFRow.<init>(HSSFRow.java:70)
        at org.apache.poi.hssf.usermodel.HSSFSheet.createRow(HSSFSheet.java:213)
        at org.apache.poi.hssf.usermodel.HSSFSheet.createRow(HSSFSheet.java:79)
        at org.omnaest.i18nbinder.internal.XLSFile.store(XLSFile.java:138)
        at org.omnaest.i18nbinder.I18nBinder.createXLSFileFromFiles(I18nBinder.java:156)
        at org.omnaest.i18nbinder.I18nBinder.run(I18nBinder.java:103)
        at org.omnaest.i18nbinder.I18nBinder.execute(I18nBinder.java:73)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
        at org.apache.tools.ant.Task.perform(Task.java:348)
        at org.apache.tools.ant.Target.execute(Target.java:392)
        at org.apache.tools.ant.Target.performTasks(Target.java:413)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
        at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
        at org.apache.tools.ant.Main.runBuild(Main.java:811)
        at org.apache.tools.ant.Main.startAnt(Main.java:217)
        at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
        at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)

Original issue reported on code.google.com by petr.oli...@gmail.com on 17 May 2012 at 12:47

[GoogleCodeExporter]

There is now added support for xlsx files from version 0.1.13+

AND

to process such large files there is now a simple caching mechanism introduced 
as well

My test with 80000 keys needed about 10minutes to complete with <512mb memory 
footprint

Can you please verify that this words for you?

Original comment by awonderl...@googlemail.com on 18 May 2012 at 10:11

• Changed state: Fixed