poi apache compress实现excel压缩下载

zcl_ccc

try {
//构造40W条数据
    List list =  this.getBranch();
    HSSFWorkbook workbook = Service.createHSSFWorkbook(list);
    String fileName = "中文名字哈哈哈";
    OutputStream out = new BufferedOutputStream(response.getOutputStream());
//压缩下载 实测80M 压缩完16M 下载更快些
    if (workbook != null) {
        fileName = fileName+ DateUtil.getExcelDate(new Date()) + ".xls";
        response.setContentType( "application/octet-stream ");  
        response.setHeader("Content-Disposition","attachment;filename=\""+  java.net.URLEncoder.encode(fileName, "UTF-8")+".zip"+"\"");
        ArchiveOutputStream archOuts = new ArchiveStreamFactory().createArchiveOutputStream(ArchiveStreamFactory.ZIP,new BufferedOutputStream(out));  
        ZipArchiveOutputStream zipOut=(ZipArchiveOutputStream)archOuts;
        ZipArchiveEntry zipEntry=new ZipArchiveEntry(fileName);  
        zipOut.putArchiveEntry(zipEntry);  
        workbook.write(zipOut);
        zipOut.closeArchiveEntry();  
      zipOut.flush();  
      zipOut.finish();  
      out.close();   
}
} catch (Exception e) {
logger.error("Controller>>>>>>>>>>>>>报表下载失败",e);
}
//生成workbook
@Override
public HSSFWorkbook createHSSFWorkbook(List list) {
    HSSFWorkbook workbook = new HSSFWorkbook();
    long totle = list.size();//获取总数，在excel分页
    float res=Float.parseFloat(String.valueOf(totle));  
    int mus=40000;  //xls文件一个sheet最多有65536条数据
    float avg=res/mus;  //分多少sheet页
    for (int k = 0; k < avg; k++) {
    HSSFSheet sheet = workbook.createSheet("第"+k+"页");
    sheet.setDefaultColumnWidth(30);  
    sheet.setDefaultRowHeightInPoints(20);
    HSSFCellStyle style = workbook.createCellStyle();
        // 创建字体对象   
    Font ztFont = workbook.createFont();
    HSSFRow row = sheet.createRow(0);
    String[] headers = { "机构编号", "机构名称", "机构级别", "父机构名称", "机构负责人", "机构负责人联系方式", "机构状态", "座机电话"};
    for (short i = 0; i < headers.length; i++) {
        HSSFCell cell = row.createCell(i);
        HSSFRichTextString text = new HSSFRichTextString(headers);
        cell.setCellValue(text);
}
//处理循环sheet页
    List tempList = null;
    int last = (int)(avg);
    if(k==(last-1)){
    int index  = (int) (k*mus);
    //tempList = list.subList(index, list.size());
    //解决subList导致内存不回收，内存溢出
    tempList = this.MySubList(list,index,list.size());
    }else{
    int index  = (int) (k*mus);
    //tempList = list.subList(index,index+mus);
    tempList = this.MySubList(list,index,index+mus);
    }
    for (int i=1,j=0;j