2.导入依赖(在pom中导入)
< 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> com.alibaba</ groupId>
< artifactId> easyexcel</ artifactId>
< version> 2.1.1</ version>
</ dependency>
3.创建一个实体类(User)
package com. huyi. easyexcel. pojo;
import com. alibaba. excel. annotation. ExcelProperty;
import lombok. Data;
public class User {
@ExcelProperty ( value = "用户ID" , index = 0 )
private Long userId;
@ExcelProperty ( value = "用户名" , index = 1 )
private String userName;
@ExcelProperty ( value = "用户密码" , index = 2 )
private String passWord;
@ExcelProperty ( value = "用户邮箱" , index = 3 )
private String email;
public Long getUserId ( ) {
return userId;
}
public void setUserId ( Long userId) {
this . userId = userId;
}
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;
}
public String getEmail ( ) {
return email;
}
public void setEmail ( String email) {
this . email = email;
}
public User ( Long userId, String userName, String passWord, String email) {
this . userId = userId;
this . userName = userName;
this . passWord = passWord;
this . email = email;
}
public User ( ) {
}
}
4.在项目的test中测试
package com. huyi. easyexcel;
import java. util. ArrayList;
import java. util. List;
import org. junit. jupiter. api. Test;
import org. springframework. boot. test. context. SpringBootTest;
import com. alibaba. excel. EasyExcel;
import com. huyi. easyexcel. pojo. User;
@SpringBootTest
class EasyexcelApplicationTests {
@Test
void contextLoads ( ) {
String fileName = "E:\\test.xlsx" ;
List< User> userList = new ArrayList < User> ( ) ;
for ( int i= 0 ; i< 18 ; i++ ) {
Long userId = ( long ) i+ 1 ;
User user = new User ( ) ;
user. setUserId ( userId) ;
user. setUserName ( "name" + userId) ;
user. setPassWord ( "password" + userId) ;
user. setEmail ( "xxx@163.com" ) ;
userList. add ( user) ;
}
for ( User user: userList) {
System. err. println ( user. getUserName ( ) ) ;
}
EasyExcel. write ( fileName, User. class ) . sheet ( "用户表" ) . doWrite ( userList) ;
}
}
5.运行结果如下