springboot集成阿里easyExcel

最新推荐文章于 2025-04-23 07:06:01 发布

置顶 Anno丶

最新推荐文章于 2025-04-23 07:06:01 发布

阅读量650

点赞数

CC 4.0 BY-SA版权

文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_43926436/article/details/103680033

本文详细介绍了如何在Spring Boot项目中使用EasyExcel进行Excel的读写操作，包括依赖配置、实体类定义、控制器层实现及HTML页面交互，帮助读者快速上手。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

**pom文件**
	 <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
	<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>2.1.4</version>
	</dependency>
	<dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.17</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.17</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>3.1</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.16.22</version>
    </dependency>

注:easyexcel使用的是org.apache.poi的版本是3.17导入其他版本会导致版本冲突,讲道理这里导入easyexcel的包就可以不用导入org.apache.poi的包了,但是我试了好多次这个org.apache.poi的包如果不导入或者版本选择错误会报错
javaBean
/**

做下载时的实体类,要映射字段与列的关系
*/
@Data
@Builder
public class DownloadData {
@ExcelProperty(“字符串标题”)
private String string;
@ExcelProperty(“日期标题”)
private Date date;
@ExcelProperty(“数字标题”)
private Double doubleData;
}

/**

做上传时接收的实体类
*/
@Data
public class Accounts {
private String name;
private String password;
private Integer age;
}

controller层
/**

@author ppshi
@date 2019/12/19 20:25
*/
@Controller
@Validated
public class ImportController {

/**
- 选择好文档直接上传,前提是要创建好对应的实体类
- @param
- @return
- @throws Exception
  */
  @PostMapping(value = “/upload”)
  @ResponseBody
  public String uploadExcel(MultipartFile file) {
  try {
  EasyExcel.read(file.getInputStream(), Accounts.class, new DemoDataListeners()).sheet().doRead();
  } catch (IOException e) {
  e.printStackTrace();
  }
  return “success”;
  }
/**
- 在html页面直接下载
- @param response
- @throws IOException
  */
  @GetMapping("/download")
  public void download(HttpServletResponse response) throws IOException {
  response.setContentType(“application/vnd.ms-excel”);
  response.setCharacterEncoding(“utf-8”);
  String fileName = URLEncoder.encode(“测试”, “UTF-8”);
  response.setHeader(“Content-disposition”, “attachment;filename=” + fileName + “.xlsx”);
  EasyExcel.write(response.getOutputStream(), DownloadData.class).sheet(“模板1”).doWrite(getAllUser());
  }
  public static List getAllUser() {
  List userList = new ArrayList<>();
  for (int i = 0; i < 10; i++) {
  DownloadData user = DownloadData.builder().string(“李四” + i).date(new Date()).doubleData(new Double(i)).build();
  userList.add(user);
  }
  return userList;
  }
  }
  上传,下载html页面

上传