JAVA打印EXCEL问题
java.lang.IndexOutOfBoundsException: Row number must be between 0 and 65535, was <-32768>
at org.apache.poi.hssf.usermodel.HSSFRow.setRowNum(HSSFRow.java:209)
at org.apache.poi.hssf.usermodel.HSSFRow.<init>(HSSFRow.java:96)
at org.apache.poi.hssf.usermodel.HSSFSheet.createRow(HSSFSheet.java:182)
at com.dsf.upload.PublicPrintToExcel.print2Cell(PublicPrintToExcel.java:294)
at com.dsf.upload.PublicPrintToExcel.print(PublicPrintToExcel.java:251)
at com.dsf.upload.PublicPrintToExcel.printfiletoexcel(PublicPrintToExcel.java:382)
at com.dsf.upload.Q7300108PrintExcel.print(Q7300108PrintExcel.java:138)
at jsp_servlet._pub.__pagedisplayupload._jspService(__pagedisplayupload.java:105)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
组装EXCEL报错了,数据量有10W多条,如何弄呢。高手求解。。 插入时可不可以一个SHEET满了,新建一个SHEET继续插?
求源码。