实战分享之springboot+easypoi快速业务集成1

1.依赖引入

        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>4.1.0</version>
        </dependency>

2.封装easypoi工具类

```package com.wzz.utils;

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.enmus.ExcelType;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.util.HSSFColor;
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;

/**

• Excel导入导出工具类

• @author pangu
  */
  public class ExcelUtil {

  /**

  • 导出工具类
  • @param list
  • @param title
  • @param sheetName
  • @param pojoClass
  • @param fileName
  • @param isCreateHeader

  • @param response
    */
    public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass,

                            String fileName, boolean isCreateHeader, HttpServletResponse response){
    

    ExportParams exportParams = new ExportParams(title, sheetName);
    exportParams.setCreateHeadRows(isCreateHeader);
    defaultExport(list, pojoClass, fileName, response, exportParams);
    }

    /**

  • 导出工具类
  • @param list
  • @param title
  • @param sheetName
  • @param pojoClass
  • @param fileName

  • @param response
    */
    public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass,String fileName,

                            HttpServletResponse response){
    

    ExportParams exportParams = new ExportParams(title, sheetName);
    exportParams.setStyle(ExcelStyleUtil.class);
    defaultExport(list, pojoClass, fileName, response, exportParams);
    }

    public static void exportExcel(List> list, String fileName, HttpServletResponse response){
    defaultExport(list, fileName, response);
    }

    private static void defaultExport(List<?> list, Class<?> pojoClass, String fileName,

                               HttpServletResponse response, ExportParams exportParams) {
    

    //TODO设置标题颜色

    Workbook workbook = ExcelExportUtil.exportExcel(exportParams,pojoClass,list);
    if (workbook != null); downLoadExcel(fileName, response, 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 NormalException(e.getMessage());
    

    }
    }

    private static void defaultExport(List> list, String fileName, HttpServletResponse response) {
    Workbook workbook = ExcelExportUtil.exportExcel(list, ExcelType.HSSF);
    if (workbook != null);
    downLoadExcel(fileName, response, workbook);
    }

    public static List importExcel(String filePath,Integer titleRows,Integer headerRows, Class pojoClass){
    if (StringUtils.isBlank(filePath)){

     return null;
    

    }
    ImportParams params = new ImportParams();
    params.setTitleRows(titleRows);
    params.setHeadRows(headerRows);
    List list = null;
    try {

     list = ExcelImportUtil.importExcel(new File(filePath), pojoClass, params);
    

    }catch (NoSuchElementException e){

     //throw new NormalException("模板不能为空");
    

    } catch (Exception e) {

     e.printStackTrace();
     //throw new NormalException(e.getMessage());
    

    } return list;
    }

    public static List importExcel(MultipartFile file, Integer titleRows, Integer headerRows, Class pojoClass){
    if (file == null){ return null;
    }
    ImportParams params = new ImportParams();
    params.setTitleRows(titleRows);
    params.setHeadRows(headerRows);
    List list = null;
    try {

     list = ExcelImportUtil.importExcel(file.getInputStream(), pojoClass, params);
    

    }catch (NoSuchElementException e){

     // throw new NormalException("excel文件不能为空");
    

    } catch (Exception e) {

     //throw new NormalException(e.getMessage());
     System.out.println(e.getMessage());
    

    }
    return list;
    }

}
```