在jxl中编写Excel单元时出现内存不足错误(JAVA - Out Of Memory Error while writing Excel Cells in jxl)

 我正在使用JXL编写50000行和30列的excel文件。 我的代码如下所示： 
 
 for（int j = 0; j <countOfRows; j ++）{ 
 
myWritableSheet.addCell(new Label(0, j, myResultSet.getString(1), myWritableCellFormat));

myWritableSheet.addCell(new Label(1, j, myResultSet.getString(2), myWritableCellFormat));

.....

.....
 
 } 
 
 在编写单元格时，程序变得越来越慢 
 
 最后在25000行左右出现以下错误： 
 
 线程“Thread-3”中的异常java.lang.OutOfMemoryError：jxl.write.biff.WritableSheetImpl.getRowRecord上的Java堆空间（WritableSheetImpl.java:984）位于jxl.write.biff.WritableSheetImpl.addCell（WritableSheetImpl.java:951 ）在KLL.ConverterMainFrame $ exportToXLSBillRightsThread.run（ConverterMainFrame.java:6895） 
 
 在Java中处理内存总是很困难。 
 
 在这种情况下，它似乎是jxl的问题。 
 
 有没有办法写出文件，清除内存，并coninue每1000个单元格写入单元格？ 
 
 这会是一个好主意吗？或者你会提出什么样的解决方案？ 

I am using JXL to write an excel file of 50000 rows and 30 columns. My code looks like this:
 
for (int j = 0; j < countOfRows; j++) {
 
myWritableSheet.addCell(new Label(0, j, myResultSet.getString(1), myWritableCellFormat));

myWritableSheet.addCell(new Label(1, j, myResultSet.getString(2), myWritableCellFormat));

.....

.....
 
}
 
While writing the cells, the program goes slower and slower 
 
and finally around the row 25000 I am getting the following error:
 
Exception in thread "Thread-3" java.lang.OutOfMemoryError: Java heap space at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:984) at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:951) at KLL.ConverterMainFrame$exportToXLSBillRightsThread.run(ConverterMainFrame.java:6895)
 
It's always difficult in Java to handle the memory.
 
In this case it seems to be the jxl's problem.
 
Is there a way to write the file, clear the memory and coninue writing cells every 1000 cells?
 
Would that be a good idea or what else would you propose as a solution?

原文：https://stackoverflow.com/questions/3167029