java实现下载excel文件

 List<EmailRecordVO> ers = queryEmailRecordList(query);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
        String filename = "邮件发送日志.xlsx";
        ByteArrayOutputStream buffer = new ByteArrayOutputStream();
        ServletOutputStream sos = null;
        try {
            sos = response.getOutputStream();
        //创建Excel对象
        SXSSFWorkbook wb = new SXSSFWorkbook(-1);
        //创建sheet页面
        Sheet spreadsheet = wb
                .createSheet("sheet");
        //创建行
        Row row = spreadsheet.createRow(0);
        Cell cell;
        for (int i = 0; i < 3; i++) {
            switch (i) {
                case 0:
                    cell = row.createCell(0);
                    cell.getCellStyle().setWrapText(true);
                    cell.setCellValue("提数时间");
                    break;
                case 1:
                    cell = row.createCell(1);
                    cell.getCellStyle().setWrapText(true);
                    cell.setCellValue("整理时间");
                    break;
           
                default:
                    break;
            }
        }
        int s = 1;
        for (int j = 0; j < ers.size(); j++) {
            row = spreadsheet.createRow(s);
            for (int d = 0; d < 3; d++) {
                switch (d) {
                    case 0:
                        cell = row.createCell(0);
                        cell.getCellStyle().setWrapText(true);
                        cell.setCellValue(sdf.format(ers.get(j).getExeTime()));
                        break;
                    case 1:
                        row.createCell(1).setCellValue(sdf.format(ers.get(j).getCreateTime()));
                        break;
                    case 2:
                        cell = row.createCell(2);
                        cell.getCellStyle().setWrapText(true);
                        cell.setCellValue(ers.get(j).getProvince());
                        break;
                   
                    default:
                        break;
                }
            }
            s++;
        }
        wb.write(buffer);
        filename = new String(filename.getBytes(), "ISO-8859-1");
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/x-download");
        response.addHeader("Content-Disposition", "attachment;filename=" + filename);
        response.setContentType("application/vnd.ms-excel");
        response.setContentLength(buffer.size());
        response.setHeader("Content-Disposition", "attachment; filename="
                + filename);
        response.setHeader("Pragma", "public");
        response.setHeader("Cache-Control", "max-age=0");
        //设置输出项
        sos.write(buffer.toByteArray());
        buffer.flush();
        sos.flush();
        wb.close();
        } catch (IOException e) {
            e.printStackTrace();
        }