Java使用easyExcel生成excel文件直接写入邮件附件并发送

1.引入pom依赖

<!-- 邮箱 -->
  <dependency>
     <groupId>org.apache.commons</groupId>
     <artifactId>commons-email</artifactId>
     <version>1.4</version>
    </dependency>
  <!-- easyexcel-->
  <dependency>
     <groupId>cn.afterturn</groupId>
     <artifactId>easypoi-spring-boot-starter</artifactId>
     <version>4.0.0</version>
  </dependency>
  <dependency>
     <groupId>org.apache.poi</groupId>
     <artifactId>poi</artifactId>
     <version>4.1.2</version>
   </dependency>
 

1.创建邮箱是实体类`

import lombok.Data;
import java.util.List;

/**
 * 创建邮箱实体类
 *
 * @author ZL
 */
@Data
public class CreateExcelSendEmailVo<T> {
   
   
    /**
     * 生成excel的数据
     */
    private List<T>dataList;

    /**
     * excel的表头
     */
    private List<String> tableHeadList;

    /**
     * 邮件的标题
     */
    private String emailTitle;

    /**
     * 邮件内容
     */
    private String emailContent;

    /**
     * 邮件收件人邮箱，支持多个收件人邮箱
     */
    private List<String> acceptAddressList;
}

2.工具类（这里是两个工具类，别看错了）

import com.alibaba.excel.metadata.BaseRowModel;
import org.springframework.stereotype.Component;

/**
 * @author ZL
 */
@Component
public class ExcelFactory<T extends BaseRowModel> {
   
   
 
    public ExportExcelUtil<T> createExportExcel() {
   
   
        return new ExportExcelUtil<>();
    }
}



import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.BaseRowModel;
import com.alibaba.excel.metadata.Sheet;
import com.alibaba.excel.metadata.Table;
import com.alibaba.excel.support.ExcelTypeEnum;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Component;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

/**
 * Excel创建工具类
 *
 * @author ZL
 */
@Component
@Slf4j
public class ExportExcelUtil