easyuiPoi导出Excel工具类封装（支持合并单元格）

package com.dyjw.infocenter.bikanban.util; import cn.afterturn.easypoi.excel.ExcelExportUtil; import cn.afterturn.easypoi.excel.ExcelImportUtil; import cn.afterturn.easypoi.excel.entity.ExportParams; import cn.afterturn.easypoi.excel.entity.ImportParams; import cn.afterturn.easypoi.excel.entity.TemplateExportParams; import cn.afterturn.easypoi.excel.entity.enmus.ExcelType; import cn.afterturn.easypoi.excel.html.helper.MergedRegionHelper; import cn.afterturn.easypoi.exception.excel.ExcelExportException; import cn.afterturn.easypoi.util.PoiMergeCellUtil; import org.apache.commons.lang3.StringUtils; import org.apache.poi.ss.usermodel.Workbook; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.io.File; import java.io.IOException; import java.net.URLEncoder; import java.util.List; import java.util.Map; import java.util.NoSuchElementException; /** * ClassName: ExcelUtils * Function: TODO Excel导出导入工具 * Date: 2019/9/18 9:34 * author hanKongbin * version V1.0 */ public class ExcelUtils { /** * 模板导出 * @param fileName * @param response * @param exportParams * @param data */ public static void exportExcel(String fileName, HttpServletResponse response, TemplateExportParams exportParams, Map<String, Object> data) { defaultExport(fileName, response, exportParams, data); } /** * 动态生成 * * @param list * @param pojoClass * @param fileName * @param response * @param exportParams */ private static void defaultExport(List<?> list, Class<?> pojoClass, String fileName, HttpServletResponse response, ExportParams exportParams) { Workbook workbook = ExcelExportUtil.exportExcel(exportParams, pojoClass, list); if (workbook != null) ; downLoadExcel(fileName, response, workbook); } /** * 模板导出 * * @param fileName 文件名称 * @param response * @param exportParams 模板那参数 * @param data 导出数据 */ private static void defaultExport(String fileName, HttpServletResponse response, TemplateExportParams exportParams, Map<String, Object> data) { Workbook workbook = ExcelExportUtil.exportExcel(exportParams, data); //纵向合并单元格 PoiMergeCellUtil.mergeCells(workbook.getSheet("教学报表"),0,0,1); if (workbook != null) ; downLoadExcel(fileName, response, workbook); } /** * 下载 * @param fileName * @param response * @param workbook */ private static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) { try { response.setCharacterEncoding("UTF-8"); response.setHeader("content-Type", "application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8")); workbook.write(response.getOutputStream()); } catch (IOException e) { throw new ExcelExportException(e.getMessage()); } } public static <T> List<T> importExcel(String filePath, Integer titleRows, Integer headerRows, Class<T> pojoClass) { if (StringUtils.isBlank(filePath)) { return null; } ImportParams params = new ImportParams(); params.setTitleRows(titleRows); params.setHeadRows(headerRows); List<T> list = null; try { list = ExcelImportUtil.importExcel(new File(filePath), pojoClass, params); } catch (NoSuchElementException e) { throw new ExcelExportException("模板不能为空"); } catch (Exception e) { e.printStackTrace(); throw new ExcelExportException(e.getMessage()); } return list; } public static <T> List<T> importExcel(MultipartFile file, Integer titleRows, Integer headerRows, Class<T> pojoClass) { if (file == null) { return null; } ImportParams params = new ImportParams(); params.setTitleRows(titleRows); params.setHeadRows(headerRows); List<T> list = null; try { list = ExcelImportUtil.importExcel(file.getInputStream(), pojoClass, params); } catch (NoSuchElementException e) { throw new ExcelExportException("excel文件不能为空"); } catch (Exception e) { throw new ExcelExportException(e.getMessage()); } return list; } }