EasyExcel导出工具类

LYH&

已于 2022-02-22 16:42:58 修改

阅读量405

点赞数

文章标签： java

于 2022-02-22 16:42:39 首次发布

本文链接：https://blog.csdn.net/qq_42759832/article/details/123071891

版权

EasyExcel导出工具类

public class ExcelUtil {
    private static final int RESPONSE_SUCCESS_CODE = 200;


    /**
     * 通用导出
     * @param list 数据源（用于生成excel表的数据）
     * @param response
     * @param clazz 对象类型（用于生成excel的表头）
     */
    public static void fileExport(List<?> list, HttpServletResponse response, Class<?> clazz) {
        try {
            writeExcel(response, list, System.currentTimeMillis() + "", System.currentTimeMillis() + "", clazz);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void writeExcel(HttpServletResponse response, List<? extends  Object> data, String fileName, String sheetName, Class clazz) throws IOException {
        // excel表头样式设置
        WriteCellStyle headWriteCellStyle = new WriteCellStyle();
        WriteFont headWriteFont = new WriteFont();
        headWriteFont.setFontHeightInPoints((short)20);
        headWriteCellStyle.setWriteFont(headWriteFont);
        // excel内容样式设置
        WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
        WriteFont contentWriteFont = new WriteFont();
        contentWriteFont.setFontHeightInPoints((short)14);
        contentWriteCellStyle.setWriteFont(contentWriteFont);
        // 策略
        HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
        EasyExcel.write(getOutputStream(fileName, response), clazz).registerWriteHandler(horizontalCellStyleStrategy).sheet(sheetName).doWrite(data);
    }

    private static OutputStream getOutputStream(String fileName, HttpServletResponse response) throws IOException {
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
        response.setStatus(RESPONSE_SUCCESS_CODE);
        return response.getOutputStream();
    }

}