springboot 发送带excel附件的邮件

最新推荐文章于 2024-11-16 09:33:13 发布

原创最新推荐文章于 2024-11-16 09:33:13 发布 · 4.2k 阅读

7 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

23 篇文章

订阅专栏

该博客介绍如何在SpringBoot应用中动态查询数据，生成Excel文件，并将其作为邮件附件发送。通过引用相关教程，详细阐述了实现这一功能的步骤和方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

从程序中动态查询出数据，生成excel文件，再加入到附件中

  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 "邮件已发送";
    }

参考：

https://blog.youkuaiyun.com/chinawszjr/article/details/53490633

https://blog.youkuaiyun.com/codes_life/article/details/79989166

https://www.jianshu.com/p/5eb000544dd7