用poi工具类实现excel导出

最近领导让做一个excel导出的功能
其实做excel导出的功能 可以有两种方案 1 用目前这种 2用阿里的easyExcel

//用poi实现导出excel
SimpleDateFormat sdf = new SimpleDateFormat(“yyyy-MM-dd”);
StringBuffer fileNameBuffer = new StringBuffer("");
fileNameBuffer.append(“信息表”).append("-").append(sdf.format(new Date())).append(".xls");
String filename = URLEncoder.encode(fileNameBuffer.toString(), “UTF-8”);
String shellNameObjects[] = {
“信息表”
};
//列名定义
String shellHeaderObjects[][] = new String[][]{
{“文章名字”, “文章内容”, “创建时间” },
};
// {“文章名字”, “文章内容”, “创建时间” } 自定义的表头字段
HSSFWorkbook wb = new HSSFWorkbook();
HSSFCellStyle style = wb.createCellStyle();
//创建表格名称
HSSFSheet sheet0 = wb.createSheet(shellNameObjects[0]);
//设置每行每列单元格大小
sheet0.autoSizeColumn(1, true);
//单独设置每列的宽度：这个非常有用，假设有些列内容过长时，就需要设置一定的长度显示内容了。不设置则使用默认宽度。
sheet0.setColumnWidth(0 , 25 * 256);
//sheet0.setColumnWidth(2 , 80 * 256);
//创建（填充）表格标题（表格第一行）
HSSFRow sheet0HeaderRow = sheet0.createRow(0);
sheet0HeaderRow.setHeightInPoints(20);
for (int i = 0; i < shellHeaderObjects[0].length; i++) {
HSSFCell cell = sheet0HeaderRow.createCell((short) i);
cell.setCellValue(shellHeaderObjects[0][i]);
cell.setCellStyle(style);
}
ListadiceInfoLists=new ArrayList<>();

        //填充表格（单元格）内容
        if (null != adiceInfoList && adiceInfoList.size() > 0)
        {
            //从表格第二行开始填充，因为第一行已经填充标题了
            int index = 1;
            for (AdiceInfo bean: adiceInfoList){
                HSSFRow sheetRow = sheet0.createRow(index);
                sheetRow.setHeightInPoints(30);//目的是想把行高设置成20px
                sheetRow.createCell(0).setCellValue(des.decrypt(bean.getTitleName()));
                sheetRow.createCell(1).setCellValue(des.decrypt(bean.getContentText()));
                sheetRow.createCell(2).setCellValue(bean.getCreateTime());
                index++;
            }
        }
        OutputStream out = response.getOutputStream();
        response.setHeader("Cache-Control", "private");
        response.setHeader("Pragma", "private");
        response.setContentType("application/vnd.ms-excel;charset=utf-8");
        response.setHeader("Content-Type", "application/force-download");
        response.setHeader("Content-disposition", "attachment;filename=" + filename);
        wb.write(out);
        out.flush();
        out.close();
        **return null;**
    }catch (Exception e){
        e.printStackTrace();
        return Result.error(CodeMsg.DOWN_FAILURE);
    }