<dependency>            <groupId>org.apache.poi</groupId>            <artifactId>poi</artifactId>            <version>3.15</version>        </dependency>        <dependency>            <groupId>org.apache.poi</groupId>               <artifactId>poi-ooxml</artifactId>               <version>3.15</version>        </dependency>

private List<Map<String, Object>> createList(List<User> users){        if(null == users) {            return null;        }        String[] keys = {"name", "gender", "phoneNo", "email"};        String[] excelHeader = {"姓名","性别", "手机号", "邮箱"};        List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();        Map<String, Object> model = new HashMap<String, Object>();        model.put("fileName", "用户表" + new Date().getTime());        model.put("sheetName", "表一");        model.put("title", "用户表");        model.put("keys", keys);        model.put("excelHeader", excelHeader);        list.add(model);                for(User user : users) {            Map<String, Object> map = new HashMap<String, Object>();            map.put("name", user.getName());            map.put("gender", user.getGender());            map.put("phoneNo", user.getPhoneNo());            map.put("email", user.getEmail());            list.add(map);        }        return list;    }

private static final Logger        LOG    = LoggerFactory.getLogger(ExcelUtil.class);    /**创建一个excel文件*/    private static Workbook createWorkBoot(String title,            String[] excelHeader, List<Map<String, Object>> list, String[] keys) {        Workbook workbook = new HSSFWorkbook();        //设置sheet的名字        Sheet sheet = workbook.createSheet(list.get(0).get("sheetName").toString());        /*设置表格宽度*/        for(int i = 0; i < keys.length; i++){            sheet.setColumnWidth(i, 35*150);        }        /*font样式设置字体大小,是否加粗*/        Font titleFont = createFont(workbook, (short)20, true);        Font headerFont = createFont(workbook, (short)12, true);        Font bodyFont = createFont(workbook, (short)12, false);        /*cell通用样式*/        CellStyle titleStyle = createStyle(workbook, titleFont);        CellStyle headerStyle = createStyle(workbook, headerFont);        CellStyle bodyStyle = createStyle(workbook, bodyFont);                // excel中当前行索引        int index = 0;        /*合并标题的单元格设置标题信息及样式 */        sheet.addMergedRegion(new CellRangeAddress(index, index, index,                excelHeader.length - 1));        Row titleRow = sheet.createRow(index++);        Cell titleCell = titleRow.createCell(0);        titleCell.setCellValue(title);        titleCell.setCellStyle(titleStyle);                /*设置表格头信息及样式*/        Row headerRow = sheet.createRow(index++);        for(int i = 0; i < excelHeader.length; i++) {            Cell headerCell = headerRow.createCell(i);            headerCell.setCellValue(excelHeader[i]);            headerCell.setCellStyle(headerStyle);        }                /*设置每行每 列的值及样式         *Row为行,cell为方格         *创建i*j个方格并设置对应的属性值*/        for(int i = 1; i < list.size(); i++) {            Row bodyRow = sheet.createRow(index++);            for (int j = 0; j < keys.length; j++) {                Cell bodyCell = bodyRow.createCell(j);                bodyCell.setCellValue(list.get(i).get(keys[j]) == null ?                         " " : list.get(i).get(keys[j]).toString());                bodyCell.setCellStyle(bodyStyle);            }        }        return workbook;    }        /**设置字体大小，颜色，样式，是否加粗*/    private static Font createFont(Workbook workbook,            short fontHeightInPoints, boolean isBlod) {        Font font = workbook.createFont();        //字体大小        font.setFontHeightInPoints(fontHeightInPoints);        //字体颜色        font.setColor(IndexedColors.BLACK.getIndex());        //字体样式        font.setFontName("宋体");        //是否加粗        font.setBold(isBlod);        return font;    }        /**设置字体居中显示，背景色，边框*/    private static CellStyle createStyle(Workbook workbook, Font font) {        CellStyle cellStyle = workbook.createCellStyle();        cellStyle.setFont(font);        //居中        cellStyle.setAlignment(HorizontalAlignment.CENTER);        //背景颜色        cellStyle.setFillForegroundColor(IndexedColors.WHITE.index);        cellStyle.setFillBackgroundColor(IndexedColors.WHITE.index);        cellStyle.setFillPattern(FillPatternType.FINE_DOTS);        //边框        cellStyle.setBorderBottom(BorderStyle.THIN);        cellStyle.setBorderLeft(BorderStyle.THIN);        cellStyle.setBorderRight(BorderStyle.THIN);        cellStyle.setBorderTop(BorderStyle.THIN);        return cellStyle;    }    public static boolean exportExcel(HttpServletResponse response,List<Map<String, Object>> list) throws IOException {        String fileName = list.get(0).get("fileName").toString();        String[] excelHeader = (String [])list.get(0).get("excelHeader");        String[] keys = (String [])list.get(0).get("keys");        String title = list.get(0).get("title").toString();                ByteArrayOutputStream baos = new ByteArrayOutputStream();        try {            createWorkBoot(title, excelHeader, list, keys).write(baos);        } catch (IOException e) {            LOG.error("将workbook中信息写入输出流时失败");            return false;        }        byte[] content = baos.toByteArray();        InputStream is = new ByteArrayInputStream(content);        response.reset();        response.setContentType("application/vnd.ms-excel;charset=utf-8");        BufferedInputStream bis = null;        BufferedOutputStream bos = null;        try {            response.setHeader("Content-Disposition", "attachment;filename="                    + new String((fileName + ".xls").getBytes(), "iso-8859-1"));            ServletOutputStream sos = response.getOutputStream();            bis = new BufferedInputStream(is);            bos = new BufferedOutputStream(sos);            byte[] buff = new byte[2048];            int byteRead = 0;            while (-1 != (byteRead = bis.read(buff, 0, buff.length))) {                bos.write(buff, 0, byteRead);            }        } catch (IOException e) {            LOG.error("创建excel文件时失败");            return false;        } finally {            if (bos != null)                bos.close();            if (bis != null)                bis.close();            if(is != null)                is.close();            if(baos != null)                baos.close();        }        return true;    }