springboot 发送带excel附件的邮件

电玩女神 2023-07-25 09:54 45阅读 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>各位老师好：</body>"); 
        sb.append("<body>本邮件为系统自动发送，如有问题请联系Hello迈迪技术部。</body>"); 
        sb.append("<body>祝好！</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 "邮件已发送";

————