Java export Excel exceeds 65,536 processingIt Community referral information-itindex.netAPRPOI package export Excel exceeds 65536 error:
Java.lang.IllegalArgumentException:Invalid row number (65536) outside allow
Workaround 1:XSS Replace HSS
Poi by:
Xssfworkbook wb = new Xssfworkbook ();
Xssfsheet sheet1= wb.createsheet ("test");
Support office2007, can be more than 65536 rows, when the data is more, will report memory overflow error, workaround see: http://blog.csdn.net/wula0010/article/details/5329817, adjust the JVM stack size settings
Download Latest POI
http://mirrors.cnnic.cn/apache/poi/release/bin/
Add to Package
Poi-3.11\ All jar Packages
Poi-3.11\ooxml-lib: three jar Packages
Http://zhidao.baidu.com/link?url=KOqR8H7HuvNMjPLd1aXJqFUt5ZYTk43_9YvMVw32t7G1NZgXPW_eEDR79qoE2Ns3IDKtNfmS7rHu0beLHN9kwK
Workaround 2:
Use Jxl.jar to export Excel
Sample code: Trace Item Cn.elamda.common.service.impl.CommonService
Method: Excelexp (String filenamebegin,string sheetname,string[] headers,list<object[]> List)
http://blog.csdn.net/jarvis_java/article/details/4924099
Java export Excel exceeds 65,536 processing (RPM)