示例
Test
@Data
class Person{
private Integer id;
private String name;
private Integer age;
}
@Data
class Fruit{
private Integer id;
private String name;
private Double price;
}
public class Test {
private static final String write_path="e:"+ File.separator+"java"+File.separator+"easyexcel"+File.separator+"write2.xlsx";
private static List<Person> data(){
List<Person> list=new ArrayList<>();
for (int i=0;i<5;i++){
Person person=new Person();
person.setId(i);
person.setName("瓜田李下"+i);
person.setAge(20+i);
list.add(person);
}
return list;
}
private static List<Fruit> data2(){
List<Fruit> list=new ArrayList<>();
for (int i=0;i<5;i++){
Fruit fruit=new Fruit();
fruit.setId(i);
fruit.setName("apple"+i);
fruit.setPrice((double)(4+i));
list.add(fruit);
}
return list;
}
public static void write(){
ExcelWriter excelWriter=null;
try{
excelWriter= EasyExcel.write(write_path).build();
WriteSheet writeSheet=EasyExcel.writerSheet().build();
WriteTable writeTable=EasyExcel.writerTable(0).head(Person.class).needHead(true).build();
WriteTable writeTable2=EasyExcel.writerTable(1).head(Fruit.class).needHead(true).build();
excelWriter.write(data(),writeSheet,writeTable);
excelWriter.write(data2(),writeSheet,writeTable2);
}finally {
if (excelWriter!=null){
excelWriter.finish();
}
}
}
public static void main(String[] args){
write();
}
}
************
使用测试
本文地址:https://blog.csdn.net/weixin_43931625/article/details/107589581
如对本文有疑问, 点击进行留言回复!!
NullPointerException: Attempt to invoke virtual method ‘android.content.res.XmlResourceParser androi
关于启动appium-desktop,报错:Cannot extract apk info using apkanalyzer. Falling back to aapt. Original ....
Gradle 发布共享库——如何通过Gradle发布Android依赖库(aar)到 jitpack 公共仓库
Gradle 发布共享库——如何通过Gradle发布java依赖库(jar)到 jitpack 公共仓库(—)
网友评论