写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 ;