java海量数据导出xls分页解决报内存溢出问题

    /**
     * 写XLS文件
     * @param fileName 文件名（全路径）
     * @param colTitleList 标题
     * @param colPorpertyList 如果属性列 为NULL，则resultData 中的每个元素为一个LIST
     * @param resultData 数据
     * @throws Exception
     */
    public static void writeXLS(HttpServletResponse response,String fileName,List colTitleList,List colPorpertyList,List resultData) throws Exception  {
        if (resultData == null)
            resultData = new ArrayList();
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"+fileName+" data count="+resultData.size());
    int maxCount = 65536;//每页数据最多65536行
    boolean bNeedTitle = true;//每页是否要加上标题一行
        if (colTitleList == null || colTitleList.size() ==0)
        bNeedTitle = false;
       
    HSSFWorkbook workBook = new HSSFWorkbook();
    int nDataPerPage = maxCount;//每页数据条数.
    if (bNeedTitle)
    nDataPerPage = maxCount-1;
    //SHEET数
    int sheetCount = resultData.size()/nDataPerPage;
    if (resultData.size()%nDataPerPage!=0)
    sheetCount++;
   
    //如果无数据，则只添加标题行
    if (sheetCount == 0){
       HSSFSheet sheet = workBook.createSheet("sheet0");
            if (bNeedTitle){
                HSSFRow row = sheet.createRow(0);
                addSheetRow(colTitleList,row);
            }
    }
    OutputStream ouputStream = null;
    int rowIndex = 0;//当前数据写到第几行的索引值
    for(int i=0;i<sheetCount;i++) {
    System.out.println("页码======"+i);
    HSSFSheet sheet = workBook.createSheet("sheet"+i);
  
    int dIndex = 0;
    //添加标题
    if (bNeedTitle){
    HSSFRow row = sheet.createRow(dIndex++);
    addSheetRow(colTitleList,row);
    }
   
    //添加数据
    while(dIndex < maxCount) {
    //System.out.println("条数"+dIndex);
    HSSFRow tempRow = sheet.createRow(dIndex++);//建立新行
    List rowDataObj = null;
    if (colPorpertyList == null)//如果没有传属性列，则resultData 中的每个元素为一个LIST
       rowDataObj = (List)resultData.get(rowIndex++);
    else rowDataObj= getRowData(colPorpertyList,resultData.get(rowIndex++));
       addSheetRow(rowDataObj,tempRow);
       
    //全部写完了
        if (rowIndex == resultData.size())break;
    }
    }
   
    ouputStream = response.getOutputStream();
//数据流输出
response.setContentType("application/vnd.ms-excel");  
response.setHeader("Content-disposition", "attachment;filename ="+fileName+".xls"); 
workBook.write(ouputStream);
ouputStream.flush();  
ouputStream.close();
//OutputStream fos = new BufferedOutputStream(new FileOutputStream(new File("D:/down/aa.xls")),1024);
//workBook.write(fos);
//fos.flush();
//fos.close();

    }

/**
     * 添加标题
     * @param colTitleList
     * @param row
     */
    private static void addSheetRow(List rowDataList,HSSFRow row){
    if (rowDataList == null || rowDataList.size() == 0)return;
Iterator tIter = rowDataList.iterator();
int index = 0;
while (tIter.hasNext()) {
HSSFCell cell = row.createCell((short)index++);
//cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(String.valueOf(tIter.next()));
}
    }

经测试 下载一百多万的数据 查询要一分半 导出要三分钟左右，不会报内存溢出  但是数据量太大 xls 文件无法打开  推荐把文件分开放入zip中。