EasyExcel3.0读(日期、数字或者自定义格式转换)

EasyExcel 3.0读(日期、数字或者自定义格式转换)

依赖

        <dependency>
    <groupId>com.alibabagroupId>
    <artifactId>easyexcelartifactId>
    <version>3.2.1version>
dependency>
1
2
3
4
5

对象

package com.xiaobu.entity.vo;

import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.format.NumberFormat;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * @author tanhongwei1
 * @version 1.0.0
 * @className TestNumberData.java
 * @createTime 2023年08月31日 11:22:00
 */
@Data
public class TestNumberData implements Serializable {
    private static final long serialVersionUID = 7783147140174424666L;
    private String name;
    // @ExcelProperty(converter = StringDoubleConverter.class)
    @NumberFormat
    private Double money;

    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    // @ExcelProperty(converter = DateStringConverter.class)
    private Date employmentDate;
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

文件内容

test_number.xlsx

NAME	MONEY	EMPLOYMENT_DATE
隔壁老王	11.9	2023/8/30 14:36
隔壁老王	2	2023-08-30 14:36:07
隔壁老王	3	2023-08-30 14:36:07
隔壁老王	4	2023-08-30 14:36:07
隔壁老王	5.12	2023-08-30 14:36:07
隔壁老王	6	2023-08-30 14:36:07
隔壁老王	7	2023-08-30 14:36:07
隔壁老王	8	2023-08-30 14:36:07
隔壁老王	9	2023-08-30 14:36:07
隔壁老王	10	2023-08-30 14:36:07
隔壁老王	11	2023-08-30 14:36:07
隔壁老王	12	2023-08-30 14:36:08
隔壁老王	13	2023-08-30 14:36:09
隔壁老王	14	2023-08-30 14:36:10
隔壁老王	15	2023-08-30 14:36:11

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

读 代码

@Test
public void testNumber() {
        String fileName = "D:\\log\\test_number.xlsx";
        // 读取sheet
        EasyExcel.read(fileName, TestNumberData.class, new PageReadListener<TestNumberData>(dataList -> {
        for (TestNumberData data : dataList) {
        log.info("读取到一条数据{}", JSONUtil.toJsonStr(data));
        // bean.update(data);
        }
        log.info("【simpleUpdate】::dataList ==> 【{}】", dataList);
        })).sheet().doRead();
        }
1
2
3
4
5
6
7
8
9
10
11
12