easyexcel导出excel 简单版

1.引入maven文件

<!--easyexcel-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>3.2.1</version>
</dependency>

2.设置导出model对象

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.util.Date;

@Data
@EqualsAndHashCode
public class DemoData {
    @ExcelProperty(value = "字符串标题")
    private String string;
    @ExcelProperty(value = "日期标题")
    private Date date;
    @ExcelProperty(value = "数字标题")
    private Double doubleData;

}

3.导出方法设置

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.util.ListUtils;
import com.example.nacosdemo.model.export.DemoData;
import org.springframework.stereotype.Service;

import java.io.File;
import java.util.Date;
import java.util.List;

@Service
public class DataService {

    public void test() {
        // 1.导出文件地址
        String basePath = "D:\\test\\excel\\";
        File f = new File(basePath);
        if(!f.exists()){
            f.mkdir();
        }
        // 2.导出文件路径
        String fileName = basePath + "simpleWrite" + System.currentTimeMillis() + ".xlsx";
        
        // 3.导出数据准备
        List<DemoData> list = ListUtils.newArrayList();
        for (int i = 0; i < 10; i++) {
            DemoData data = new DemoData();
            data.setString("字符串" + i);
            data.setDate(new Date());
            data.setDoubleData(0.56);
            list.add(data);
        }
        // 4.导出
        EasyExcel.write(fileName, DemoData.class)
                .sheet("模板")
                .doWrite(list);

    }

}