excel简单的读写 easyexcel

package com.easyexcel;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.listener.PageReadListener;
import com.alibaba.fastjson2.JSON;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * 官方文档： https://easyexcel.opensource.alibaba.com/docs/current/
 * 
 * easyexcel学习 设计思想
 * excel 和  实体类属性  对应关系 >>>>> 默认全属性到处 > 指定不导出【ExcelIgnore】 > 导出的指定顺序【ExcelProperty】  > 反转【ExcelIgnoreUnannotated】
 *
 *  * ExcelIgnore -----排除
 *  * 默认所有字段都会和excel去匹配，加了这个注解会忽略该字段
 *
 * ExcelProperty
 * 用于匹配excel和实体类的匹配
 * 1/ 属性 列 的对应关系
 *    注解：字段标注
 *      1-标题名
 *      2-列顺序
 *      3-相对顺序
 *    默认：全属性 对应 列,
 *
 * ExcelIgnoreUnannotated-----反转
 * 默认不加ExcelProperty 注解的都会参与读写，加了不会参与
 *
 *  * 2/数据类型  java <----->excel ====>>>格式转换 String  接收 数字和date
 *
 */
@Slf4j
public class EasyExcelStudyOne {
    //1-变量 <--> 映射 列
    //2-写入文件，读入内存
    //2-web上传下载

    @Test
    public void easyExcelStudy1() {


        String parh = "C:\\Users\\xulin\\Desktop\\excel\\demo.xlsx";
        EasyExcel.read(parh, UserExcel.class, new PageReadListener<UserExcel>(dataList -> {
            for (UserExcel demoData : dataList) {
                log.info("读取到一条数据{}", JSON.toJSONString(demoData));
            }
        })).sheet("two1").doRead();
    }

    @Test
    public void writeDemo() {
        long st = System.currentTimeMillis();
        List list = new ArrayList<UserExcel>();
        for (int i = 0; i < 90; i++) {
            list.add(new UserExcel("one", "tow", "three", "four","111111112222222222","234"));
        }
        String parh = "C:\\Users\\xulin\\Desktop\\excel\\demo.xlsx";
        EasyExcel.write(parh, UserExcel.class).sheet("two1").doWrite(list);
        long end = System.currentTimeMillis();
        System.out.println((end - st) / 1000);
    }

}

package com.easyexcel;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.format.NumberFormat;
import com.alibaba.excel.enums.BooleanEnum;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.math.RoundingMode;
import java.util.Date;

import static com.alibaba.excel.enums.BooleanEnum.*;


@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
public class UserExcel {
//    @ExcelProperty(index=0)
//    private String one;
//    @ExcelProperty(index=1)
//    private String two;
//    @ExcelProperty(index=2)
//    private String three;
//    @ExcelProperty(index=3)
//    private String four;
    //ExcelProperty(index=0)
//ExcelProperty(index=2)
//private String three;
    //ExcelProperty(index=3)
//    private String four;
//    private String one;
//    //ExcelProperty(index=1)
//    private String two;
    //ExcelProperty(index=2)
//    private String three;
//    //ExcelProperty(index=3)
//    private String four;

    @ExcelProperty({"低劣","伤心","中国","日本"})
    private String four;
    @ExcelProperty(value="虚伪",order = 111)
    private String one;
    @ExcelProperty(value="打包",order = 222)
    private String two;
    @ExcelProperty("发布")
    private String three;
    @NumberFormat(roundingMode=RoundingMode.HALF_UP)
    private String five;
    @DateTimeFormat("yyyy:MM:dd")
    private String date;

}