idea -- mybaties -- 模板下载

1，ctroller-->如下

@GetMapping(value = "/createTlzExcel")
public String createTlzExcel(HttpServletResponse response) throws Exception {
    Map<String, Object> excelMap = new HashMap<>();
    //1.设置Excel表头
    List<String> headerList = new ArrayList<>();
    headerList.add("序号");
    headerList.add("工号");
    headerList.add("姓名");
    headerList.add("体力值");
    excelMap.put("header", headerList);
    //2.是否需要生成序号，序号从1开始(true-生成序号 false-不生成序)
    boolean isSerial = false;
    excelMap.put("isSerial", isSerial);
    //3.sheet名
    String sheetName = "体力值模板下载";
    excelMap.put("sheetName", sheetName);
    //Excel文件内容设置
    HSSFWorkbook workbook = VerifyUtil.createExcel(excelMap);
    String fileName = "体力值模板下载.xls";
    //生成excel文件
    VerifyUtil.buildExcelFile(fileName, workbook);
    //浏览器下载excel
    VerifyUtil.buildExcelDocument(fileName, workbook, response);
    return "down excel";
}

2.工具类（

VerifyUtil

）--->如下，-- 直接copy

/**
 * Excel内容设置
 *
 * @param excelMap
 */
public static HSSFWorkbook createExcel(Map<String, Object> excelMap) {

    HSSFWorkbook workbook = new HSSFWorkbook();
    String sheetName = excelMap.get("sheetName").toString();
    HSSFSheet sheet = workbook.createSheet(sheetName);

    //只考虑一个sheet的情况
    HSSFRow row = sheet.createRow(0);
    //设置列宽，setColumnWidth的第二个参数要乘以256，这个参数的单位是1/256个字符宽度
    sheet.setColumnWidth(1, 12 * 256);
    sheet.setColumnWidth(3, 17 * 256);

    //表头设置为居中加粗
    HSSFCellStyle style = workbook.createCellStyle();
    HSSFFont font = workbook.createFont();
    //font.setBoldweight((short) 14);
    //style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    style.setFont(font);
    //是否生成序号，序号从1开始
    boolean isSerial = (boolean) excelMap.get("isSerial");
    //获取表头列表
    java.util.List<String> headerList = (java.util.List<String>) excelMap.get("header");
    HSSFCell cell;

    //生成表头
    int headRow=0;
    if (isSerial){
        //设置第一个列为序号列
        cell = row.createCell(0);
        cell.setCellValue("序号");
        cell.setCellStyle(style);
        headRow = 1;

    }
    for (String header : headerList) {
        cell = row.createCell(headRow);
        cell.setCellValue(header);
        cell.setCellStyle(style);
        headRow++;
    }

    //往Excel中插入数据
    java.util.List<java.util.List<String>> data = (java.util.List<java.util.List<String>>) excelMap.get("data");

    int rowNum = 1;
    //需要生成序号
    if (isSerial){
        //表头字段包含序号一列
        int headSize = headerList.size() + 1;
        for (java.util.List<String> obj:data){
            HSSFRow currRow = sheet.createRow(rowNum);
            for (int i=1;i<headSize;i++){
                currRow.createCell(0).setCellValue(rowNum);
                currRow.createCell(i).setCellValue(obj.get(i-1));
            }
            rowNum++;
        }
        //无需生成序号
    }else{
        int headSize = headerList.size();
        if(data!=null){
            for (List<String> obj:data){
                HSSFRow currRow = sheet.createRow(rowNum);
                for (int i=0;i<headSize;i++){
                    currRow.createCell(i).setCellValue(obj.get(i));
                }
                rowNum++;
            }
        }
    }
    return workbook;
}

/**
 * 生成excel文件
 *
 * @param filename
 * @param workbook
 * @throws Exception
 */
public static void buildExcelFile(String filename, HSSFWorkbook workbook) throws Exception {
    FileOutputStream fos = new FileOutputStream(filename);
    workbook.write(fos);
    fos.flush();
    fos.close();
}

/**
 * 浏览器下载excel
 *
 * @param filename
 * @param workbook
 * @param response
 * @throws Exception
 */
public static void buildExcelDocument(String filename, HSSFWorkbook workbook, HttpServletResponse response) throws Exception {
    response.setContentType("application/vnd.ms-excel");
    response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, "utf-8"));
    OutputStream outputStream = response.getOutputStream();
    workbook.write(outputStream);
    outputStream.flush();
    outputStream.close();
}