easyexcel 使用table写入

布满荆棘的人生 2023-03-01 12:49 34阅读 0赞

--------------------

### easyexcel 使用table写入 ###

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**示例**

**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();
        }
    }

**\*\*\*\*\*\*\*\*\*\*\*\***

**使用测试**

![20200726104735929.png][]

[20200726104735929.png]: /images/20230208/6652f44c455446109cd9297286d5fee0.png