2000元阿里云代金券免费领取,2核4G云服务器仅664元/3年,新老用户都有优惠,立即抢购>>>
阿里云采购季(云主机223元/3年)活动入口:请点击进入>>>,
阿里云学生服务器(9.5元/月)购买入口:请点击进入>>>,
pom.xml
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>3.1.1</version>
</dependency>
main.java
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import java.util.ArrayList;
import java.util.List;
public class InsertDemo {
public static void main(String[] args) {
String fileName = "dd.xlsx"; // excel文件名称
// 这里 需要指定写用哪个class去写
try (ExcelWriter excelWriter = EasyExcel.write(fileName, DataInfo.class).build()) {
// 这里注意 如果同一个sheet只要创建一次
WriteSheet writeSheet = EasyExcel.writerSheet("模板").build();
// 分页去数据库查询数据 这里可以去数据库查询每一页的数据
List<DataInfo> data = list_data();
excelWriter.write(data, writeSheet);//
}
}
/**
* 构建测试数据
* @return
*/
private static List<DataInfo> list_data()
{
List<DataInfo> list = new ArrayList<>();
for (int i = 0; i < 100; i++) {
DataInfo dataInfo = new DataInfo();
dataInfo.setId(i);
dataInfo.setName("张三");
dataInfo.setAddress("中国北京");
list.add(dataInfo);
}
return list;
}
}
DataInfo.java
public class DataInfo {
private Integer id;
private String name;
private String address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public DataInfo() {
}
}