package dmybatistest.dmybatistest.model.domain;
import java.util.ArrayList;
import java.util.List;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
@Data
public class UserData {
@ExcelProperty("用户id")
private int uid;
@ExcelProperty("用户名称")
private String username;
public static void main(String[] args) {
// 要写到excel数据的list集合
List<UserData> list = new ArrayList<>();
for (int i=0; i<10; i++) {
UserData data = new UserData();
data.setUid(i);
data.setUsername("用户名称"+i);
list.add(data);
}
// 设置excel文件路径和文件名称
String fileName = "C:\\easyexcel.xlsx";
// 调用方法实现写操作
EasyExcel.write(fileName, UserData.class).sheet("用户信息")
.doWrite(list);
}
}
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>