SpringBoot实现Excel导入功能 将Excel数据转换为集合
1.导入相关依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>3.0.3</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>3.0.3</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>3.0.3</version>
</dependency>
2 :写一个实体类用来接受导入的Excel数据
public class ImportExcelModel {
@Excel(name = "用户名")
private String username;
@Excel(name = "密码")
private String password;
public ImportExcelModel() {
}
public ImportExcelModel(String username, String password) {
this.username = username;
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "ImportExcelModel{" +
"username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
Servce
工具类
集成Swagger
导入的依赖
<!-- 配置springfox-swagger2-->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.7.0</version>
</dependency>
<!-- 配置springfox-swagger-ui -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.7.0</version>
</dependency>
类上的注解
网址 ip:端口/swagger-ui.html