写Excel

com.alibaba

easyexcel

2.0.5

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import com.alibaba.excel.EasyExcel;

public class WriteTest {

public static void main(String[] args) {

String fileName = "d:/101.xlsx" ;

EasyExcel.write(fileName, User.class).sheet("模板").doWrite(data());

}

/**

* 模拟从数据库中读取数据

* @return

*/

public static List data(){

List list = new ArrayList() ;

for(int i = 1 ; i

User user = new User() ;

user.setUid("100"+i);

user.setName("name_"+i);

user.setAge(10 + i);

user.setAddress("address_"+ i);

user.setBirthday(new Date());

list.add(user) ;

}

return list ;

}

}import java.util.Date;

import com.alibaba.excel.annotation.ExcelProperty;

/**

*/

/**

* @author Martin

* @Date 2019年11月1日 下午11:36:58

* @Desc

*/

public class User {

/**

* value-->表头 index-->列(从0开始)

*/

@ExcelProperty(index = 0, value = "序号")

private String uid;

@ExcelProperty(index = 1, value = "姓名")

private String name;

@ExcelProperty(index = 2, value = "年龄")

private Integer age;

@ExcelProperty(index = 3, value = "地址")

private String address;

// converter 格式转换类

@ExcelProperty(index = 4, value = "日期")

private Date birthday;

public User() {

}

public User(String uid, String name, Integer age, String address) {

this.uid = uid;

this.name = name;

this.age = age;

this.address = address;

}

public String getUid() {

return uid;

}

public void setUid(String uid) {

this.uid = uid;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public Integer getAge() {

return age;

}

public void setAge(Integer age) {

this.age = age;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

public Date getBirthday() {

return birthday;

}

public void setBirthday(Date birthday) {

this.birthday = birthday;

}

@Override

public String toString() {

return "User [name=" + name + ", uid=" + uid + ", address=" + address + ", age=" + age + ", birthday="

+ birthday + "]";

}

}

日志：23:47:40.644 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - Begin to Initialization 'WriteContextImpl'

23:47:40.661 [main] DEBUG com.alibaba.excel.metadata.property.ExcelHeadProperty - The initialization sheet/table 'ExcelHeadProperty' is complete , head kind is CLASS

23:47:40.674 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - CurrentConfiguration is writeWorkbookHolder

23:47:40.944 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - Initialization 'WriteContextImpl' complete

23:47:40.944 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - Sheet number is null

23:47:40.945 [main] DEBUG com.alibaba.excel.metadata.property.ExcelHeadProperty - The initialization sheet/table 'ExcelHeadProperty' is complete , head kind is CLASS

23:47:40.945 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - CurrentConfiguration is writeSheetHolder

23:47:40.945 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - Can not find sheet:0 ,now create it

23:47:41.481 [main] DEBUG com.alibaba.excel.context.WriteContextImpl - Finished write.

标签：

easyexcel

出处：https://www.meihaocloud.com.com/b_199.html ， 欢迎转载，请在文章页标出原文连接 ！