easyexcel是阿里巴巴项目组提供的excel工具类。
gitHub地址:https://github.com/alibaba/easyexcel
本文基于springboot环境学习EasyExcel实现Excel数据导入数据库
EasyExcel
环境
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
Controller
@PostMapping("/excel")
public JsonResult<String> upload(MultipartFile file) throws Exception {
JsonResult<String> result =new JsonResult<>();
if(file.isEmpty()){
result.setSuccess(false);