springboot 发送带excel附件的邮件-蒲公英云

springboot 发送带excel附件的邮件

电玩女神 2023-07-25 09:54 129阅读 0赞

public String sendAttendedFileMail() throws Exception {
MimeMessage mimeMessage = mailSender.createMimeMessage();
// multipart模式
String[] tos={“abc.cn”,”def.cn”}; //收件人
String[] ccs={“z.cn”,”x.cn”,”v.cn”,”b.cn”}; //抄送人
MimeMessageHelper mimeMessageHelper = new MimeMessageHelper(mimeMessage, true, “utf-8”);
mimeMessageHelper.setTo(tos); //收件人
mimeMessageHelper.setCc(ccs); //抄送人
mimeMessageHelper.setFrom(“hellomady@163.com”);
mimeMessageHelper.setSubject(“[Hello迈迪]-分销统计-迈格森渠道”);

    StringBuilder sb = new StringBuilder();  
    sb.append("<html><head></head>");  
    sb.append("<body><p>各位老师好：</p></body>");  
    sb.append("<body><p>本邮件为系统自动发送，如有问题请联系Hello迈迪技术部。</p></body>");  
    sb.append("<body><p>祝好！</p></body>");  
    sb.append("</html>

// 启用html
mimeMessageHelper.setText(sb.toString(), true);
// 设置附件
XSSFWorkbook workbook = null;
InputStream in = null;
try {
workbook = saleYzOrderService.exportOrder(0,3012); //parentId只取前四位
//临时缓冲区
ByteArrayOutputStream out = new ByteArrayOutputStream();
//创建临时文件
workbook.write(out);
byte[] bookByteAry = out.toByteArray();
in = new ByteArrayInputStream(bookByteAry);
} catch (Exception e) {
// logger.error(“export orderList error!”, e);
}
mimeMessageHelper.addAttachment(“分销订单详情表.xlsx”, new ByteArrayResource(IOUtils.toByteArray(in)), “application/vnd.ms-excel;charset=UTF-8”);

    try \{  
        workbook = saleYzOrderService.exportCount();  
        //临时缓冲区  
        ByteArrayOutputStream out = new ByteArrayOutputStream();  
        //创建临时文件  
        workbook.write(out);  
        byte\[\] bookByteAry = out.toByteArray();  
        in = new ByteArrayInputStream(bookByteAry);  
    \} catch (Exception e) \{

// logger.error(“export orderList error!”, e);
}

    mimeMessageHelper.addAttachment("分销订单统计表.xlsx", new ByteArrayResource(IOUtils.toByteArray(in)), "application/vnd.ms-excel;charset=UTF-8");  
    // 发送邮件  
    mailSender.send(mimeMessage);  
    return "邮件已发送";