java easy-poi 导入导出demo

最新推荐文章于 2024-06-24 09:17:18 发布

ppliu-life

最新推荐文章于 2024-06-24 09:17:18 发布

阅读量404

点赞数 1

CC 4.0 BY-SA版权

分类专栏： java 工具包使用文章标签： java

本文链接：https://blog.youkuaiyun.com/PPLIU010119/article/details/125897180

需要引入的jar包

 //excel导出
    implementation group: 'cn.afterturn', name: 'easypoi-base', version: '4.2.0'
    implementation group: 'cn.afterturn', name: 'easypoi-web', version: '4.2.0'
    implementation group: 'cn.afterturn', name: 'easypoi-annotation', version: '4.2.0'

自定义工具类

FileWithExcelUtil

package com.sgmart.utils.excel;

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 lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.ss.usermodel.DataValidation;
import org.apache.poi.ss.usermodel.DataValidationConstraint;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.xssf.usermodel.XSSFDataValidationConstraint;
import org.apache.poi.xssf.usermodel.XSSFDataValidationHelper;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.Fil