用poi 写入大数据量到excel2007，总是报错，“Java heap space”，求解决....

用poi生成excel2007 创建XSSFWorkbook对象
Workbook workbook = new XSSFWorkbook(new FileInputStream(path));
Sheet sheet = workbook .createSheet("这里第一页");
FileOutputStream fos = new FileOutputStream("D://test//test0215.xlsx");
for (int i = 0; i < 100000; i++) {
sheet.createRow(i).createCell(0).setCellValue(1);
}
workbook .write(fos);[size=small]
fos.close();
上面测试例子，写入excel第一列，全为1，写入10w行，超过一定的数据量，比如10w，就会报“Exception in thread "main" java.lang.OutOfMemoryError: Java heap space” ，求解决方案？？？？

评论

1 楼 tianyafy 2012-07-19  

try {
Workbook wb = new SXSSFWorkbook(100);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
Sheet sh = wb.createSheet();
System.out.println(sh.getSheetName());
while (rs.next()) {
if (sh.getLastRowNum() - sh.getFirstRowNum() > 65433) {
count = 0;
sh = wb.createSheet();
System.out.println(sh.getSheetName());
}
Row row = sh.createRow(count);
for (int cellnum = 1; cellnum <= rs.getMetaData()
.getColumnCount(); cellnum++) {
Cell cell = row.createCell(cellnum - 1);
String value = null;
if (rs.getObject(cellnum) != null) {
value = rs.getObject(cellnum).toString();
}
cell.setCellValue(value);
}
count++;
}
out = new FileOutputStream(file);
wb.write(out);
} catch (Exception e) {
e.printStackTrace();
} finally {
out.close();
DBUtil.release(conn, stmt, rs);
}