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继续插?
求源码。
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继续插?
求源码。
你有10W多条,是无法全部插入进去的
"插入时可不可以一个SHEET满了,新建一个SHEET继续插?"
插入时可以实现判断插入进去时有多少条了,当超过65536时,就重新建立个表
在开始插入不过有点麻烦
LZ,为什么不用其他的数据库呢,MySQL呀