JAVA-POI导出功能（SXSSF）

/**
     * 设置cell样式和cell字体粗体
     * @param workbook
     * @return
     */
    private CellStyle setWkCellstyle(SXSSFWorkbook workbook, String useArea) {
        // 设置样式
        CellStyle cellStyle = workbook.createCellStyle();
        cellStyle.setAlignment(HorizontalAlignment.CENTER);// 水平居中
        cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);// 垂直居中
        cellStyle.setWrapText(true);// 自动换行
        if ("titleAndColone".equals(useArea)) {
            // 字体 粗体
            Font font = workbook.createFont();
            font.setBold(true);// 粗体显示
            cellStyle.setFont(font);// 选择需要用到的字体格式
        }
        return cellStyle;
    }

private R exportSxssfExecl(List<Map> listMap, String sheetName) throws IOException {
        // 输出流
        OutputStream outputStream = null;
        // 创建工作簿
        SXSSFWorkbook workbook = new SXSSFWorkbook(500);
        // 创建SXSSFSheet对象
        SXSSFSheet sheet = workbook.createSheet(sheetName);
        try {
            // 第一行 设置表名title
            SXSSFRow rowTitle = sheet.createRow(0);
            SXSSFCell cellTitle = rowTitle.createCell(0);
            cellTitle.setCellValue("数据统计表");
            //合并单元格CellRangeAddress构造参数依次表示起始行，截至行，起始列， 截至列
            sheet.addMergedRegion(new CellRangeAddress(0,0,0,4));
            // 设置列中写入内容为String类型
            cellTitle.setCellType(CellType.STRING);

            // 设置title和列名col样式
            CellStyle csTitleAndOnecol = setWkCellstyle(workbook, "titleAndColone");
            cellTitle.setCellStyle(csTitleAndOnecol);

            // 单元格默认宽度
            sheet.setDefaultColumnWidth(20);

            // 设置填充数据单元格样式
            CellStyle csCellContent = setWkCellstyle(workbook, "cellContent");
......

            String filename = encodingFilename(sheetName);
            outputStream = new FileOutputStream(getAbsoluteFile(filename));
            workbook.write(outputStream);
            return R.ok(filename);
        } catch (Exception e) {
            log.error("导出Excel异常{}", e.getMessage());
            throw new BusinessException("导出Excel失败，请联系网站管理员！");
        } finally {
            if (workbook != null) {
                try {
                    // 关闭工作簿
                    workbook.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
            if (outputStream != null) {
                try {
                    // 关闭输出流
                    outputStream.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
        }
    }

/**
     * 编码文件名
     * @param filename
     * @return
     */
    private String encodingFilename(String filename) {
        filename = UUID.randomUUID().toString() + "_" + filename + ".xlsx";
        return filename;
    }