使用EasyExcel导出excel文件

easyexcel版本2.2.6

public class User {
    private Integer number;
	private String name;
//get、set 方法
}

package test

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.metadata.fill.FillWrapper;

import java.io.*;
import java.util.ArrayList;
import java.util.List;

/**
 * @Description 使用easyexcel导出
 * @Version 1.0
 */
public class Export {

   private void export () {
        InputStream tempInputStream = null;
        ExcelWriter excelWriter = null;
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        try {
            //模版
            tempInputStream = new FileInputStream("E:\\test\\导出模板.xlsx");
            excelWriter = EasyExcel.write(outputStream).withTemplate(tempInputStream).build();
            WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
            //数据
            List<User> users= new ArrayList<>();
            User user = new User();
            user.setName("张三");
            user.setNumber("1");
            users.add(user);
            
            //写数据
            excelWriter.fill(new FillWrapper("users",users),writeSheet);
        }
        catch (Exception e) {
            e.printStackTrace();
        } finally {
            if(excelWriter != null) {
                excelWriter.finish();
            }
        }
        if (outputStream!=null){
            try {
                FileOutputStream out = new FileOutputStream("E:\\test\\导出.xlsx");
                out.write(outputStream.toByteArray());
            } catch (IOException ioException) {
                ioException.printStackTrace();
            }
        }
    }
}

模版配置内容

编号	姓名
{users.number}	{users.name}