Easy-POI

        <!--easy_poi-->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>4.4.0</version>
        </dependency>

package com.dj.easypoi;

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import com.dj.easypoi.model.dto.UserDto;
import com.dj.easypoi.utils.IdWorker;
import org.apache.poi.ss.usermodel.Workbook;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

/**
 * User: ldj
 * Date: 2023/5/13
 * Time: 19:49
 * Description: No Description
 */
@SpringBootTest
public class EasypoiApplicationTest {

    //造点假数据,模拟查询数据库所有用户信息
    public List<UserDto> getUsers() {
        List<UserDto> userDtoList = new ArrayList<>();
        IdWorker idWorker = new IdWorker(0, 0);
        for (int i = 0; i < 5; i++) {
            UserDto userDto = UserDto.builder()
                    .id(idWorker.nextId())
                    .username("用户" + i)
                    .age(18)
                    .password("adada1234" + i)
                    .mobile("1355823306" + i)
                    .build();
            userDtoList.add(userDto);
        }
        return userDtoList;
    }


    @Test
    public void testExport() throws IOException {
        //获取数据
        List<UserDto> userDtoList = getUsers();
        //导出Excel 1.导出配置映射对象 2.导出类型 3.导出数据集合
        ExportParams exportParams = new ExportParams("用户信息列表", "用户sheet");
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, UserDto.class, userDtoList);
        //IO流写入指定的位置(注意:如果不存在目录"F:/easypoi/" 会报错找不到指定目录)
        FileOutputStream outputStream = new FileOutputStream("F:/easypoi/users.xlsx");
        workbook.write(outputStream);
        outputStream.flush();
        outputStream.close();
        workbook.close();
    }


    @Test
    public void testImport() throws Exception {
        //1.文件输入流 2.导入类型 3.导入配置映射对象
        FileInputStream inputStream = new FileInputStream("F:/easypoi/users.xlsx");
        ImportParams importParams = new ImportParams();
        importParams.setTitleRows(1);//标题列占几行
        importParams.setHeadRows(2);//header列占几行
        importParams.setSheetNum(1);//从第页sheet读取
        List<UserDto> userDtoList = ExcelImportUtil.importExcel(inputStream, UserDto.class, importParams);
        for (UserDto userDto : userDtoList) {
            System.out.println(userDto);
        }
    }
}

package com.dj.easypoi.model.dto;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelIgnore;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import lombok.Builder;
import lombok.Data;

import java.io.Serializable;

/**
 * User: ldj
 * Date: 2023/5/13
 * Time: 19:38
 * Description: 映射excel表
 */
@Data
@Builder
@ExcelTarget("users")
public class UserDto implements Serializable {

    @Excel(name = "编号", width = 20.0, orderNum = "0")
    private Long id;

    @Excel(name = "姓名", width = 9.0, orderNum = "1")
    private String username;

    @Excel(name = "年龄", orderNum = "3", suffix = "岁")
    private Integer age;

    @ExcelIgnore //忽略字段,不导出
    @Excel(name = "密码", width = 13.0, orderNum = "4")
    private String password;

    @Excel(name = "手机号", width = 15.0, orderNum = "2")
    private String mobile;
}

//生成id的工具类

package com.dj.easypoi.utils;

/**
 * User: ldj
 * Date: 2023/5/13
 * Time: 20:01
 * Description:  雪花算法
 */
public class IdWorker {
    private final long twepoch = 1288834974657L;
    private final long workerIdBits = 5L;
    private final long datacenterIdBits = 5L;
    private final long maxWorkerId = -1L ^ (-1L << workerIdBits);
    private final long maxDatacenterId = -1L ^ (-1L << datacenterIdBits);
    private final long sequenceBits = 12L;
    private final long workerIdShift = sequenceBits;
    private final long datacenterIdShift = sequenceBits + workerIdBits;
    private final long timestampLeftShift = sequenceBits + workerIdBits + datacenterIdBits;
    private final long sequenceMask = -1L ^ (-1L << sequenceBits);

    private long workerId;
    private long datacenterId;
    private long sequence = 0L;
    private long lastTimestamp = -1L;

    public IdWorker(long workerId, long datacenterId) {
        if (workerId > maxWorkerId || workerId < 0) {
            throw new IllegalArgumentException(String.format("worker Id can't be greater than %d or less than 0", maxWorkerId));
        }
        if (datacenterId > maxDatacenterId || datacenterId < 0) {
            throw new IllegalArgumentException(String.format("datacenter Id can't be greater than %d or less than 0", maxDatacenterId));
        }
        this.workerId = workerId;
        this.datacenterId = datacenterId;
    }

    /**
     * 获得下一个ID (该方法是线程安全的)
     * @return SnowflakeId
     */
    public synchronized long nextId() {
        long timestamp = timeGen();
        //如果当前时间小于上一次ID生成的时间戳，说明系统时钟回退过这个时候应当抛出异常
        if (timestamp < lastTimestamp) {
            throw new RuntimeException(
                    String.format("Clock moved backwards.  Refusing to generate id for %d milliseconds", lastTimestamp - timestamp));
        }

        //如果是同一时间生成的，则进行毫秒内序列
        if (lastTimestamp == timestamp) {
            //如果毫秒相同，则从0递增生成序列号
            sequence = (sequence + 1) & sequenceMask;
            //毫秒内序列溢出
            if (sequence == 0) {
                //阻塞到下一个毫秒,获得新的时间戳
                timestamp = tilNextMillis(lastTimestamp);
            }
        }
        //时间戳改变，毫秒内序列重置
        else {
            sequence = 0L;
        }

        //上次生成ID的时间截
        lastTimestamp = timestamp;

        //移位并通过或运算拼到一起组成64位的ID
        return ((timestamp - twepoch) << timestampLeftShift) //
                | (workerId << workerIdShift) //
                | sequence;
    }

    protected long tilNextMillis(long lastTimestamp) {
        long timestamp = timeGen();
        while (timestamp <= lastTimestamp) {
            timestamp = timeGen();
        }
        return timestamp;
    }

    protected long timeGen() {
        return System.currentTimeMillis();
    }

    public static void main(String[] args) {
        IdWorker idWorker = new IdWorker(0, 0);
        for (int i = 0; i < 100; i++) {
            long id = idWorker.nextId();
            System.out.println(id);
        }
    }

}