poi解决java导出excel海量数据内存溢出问题详解编程语言

import java.io.FileOutputStream; 
import org.apache.commons.lang.exception.ExceptionUtils; 
import org.apache.poi.ss.usermodel.Cell; 
import org.apache.poi.ss.usermodel.Row; 
import org.apache.poi.ss.usermodel.Sheet; 
import org.apache.poi.ss.usermodel.Workbook; 
import org.apache.poi.ss.util.CellReference; 
import org.apache.poi.xssf.streaming.SXSSFWorkbook; 
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 
  
public class Test { 
    public static void main(String[] args) { 
        if (args[0].equals("hssf")) { 
            hssfTest(); 
        } 
  
        if (args[0].equals("sxssf")) { 
            sxssfTest(); 
        } 
    } 
  
    public static void sxssfTest() { 
  
        Workbook wb = new SXSSFWorkbook(100); // keep 100 rows in memory, 
        // exceeding rows will be 
        // flushed to diskSheet sh = wb.createSheet() 
        ; 
        int rownum = 0; 
        try { 
            while (true) { 
                Row row = sh.createRow(rownum); 
                for (int cellnum = 0; cellnum < 10; cellnum++) { 
                    Cell cell = row.createCell(cellnum); 
                    String address = new CellReference(cell).formatAsString(); 
                    cell.setCellValue(address); 
                } 
                System.out.println(rownum); 
                rownum++; 
                if (rownum >= 1000000) 
                    break; 
  
            } 
            FileOutputStream out = new FileOutputStream("c:/sxssf.xlsx"); 
            wb.write(out); 
            out.close(); 
        } catch (Exception e) { 
            System.out.println(ExceptionUtils.getFullStackTrace(e)); 
        } 
    } 
  
    public static void hssfTest() { 
        XSSFWorkbook wb = new XSSFWorkbook(); 
        Sheet sh = wb.createSheet(); 
        int rownum = 0; 
        try { 
            while (true) { 
                Row row = sh.createRow(rownum); 
                for (int cellnum = 0; cellnum < 10; cellnum++) { 
                    Cell cell = row.createCell(cellnum); 
                    String address = new CellReference(cell).formatAsString(); 
                    cell.setCellValue(address); 
                } 
                System.out.println(rownum); 
                rownum++; 
                if (rownum >= 1000000) 
                    break; 
            } 
            FileOutputStream out = new FileOutputStream("c:/hssf.xlsx"); 
            wb.write(out); 
            out.close(); 
        } catch (Exception e) { 
            System.out.println(ExceptionUtils.getFullStackTrace(e)); 
        } 
    } 
}