SpringBoot集成Easyexcel-写入

 	
    
        org.apache.poi
        poi
        3.17
    
    
        org.apache.poi
        poi-ooxml
        3.17
    
    
    
    
        com.alibaba
        easyexcel
        2.1.1
    

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() {
		
	}
	
}

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 userList = new ArrayList();
	        //循环写入数据
	        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);
	}

}

• 注意：文件如果打开的话运行会报错