Java以邮件附件的方式发送excel文件-CSDN博客

String to = "xxx@qq.com"; // 收件人的QQ邮箱
String from = "xxx@qq.com"; // 发件人的QQ邮箱
String authoCode = "xxx"; // 使用qq邮箱发送时的授权码
String smtpServer = "smtp.qq.com";

/**
 * 1，创建邮件对象
 */
Properties properties = new Properties();
properties.put("mail.smtp.host", smtpServer); // 指定SMTP服务器
properties.put("mail.smtp.auth", "true"); // 指定是否需要SMTP验证
Session session = Session.getInstance(properties);
MimeMessage message = new MimeMessage(session);

try {
    /**
     * 2. 设置发件人
     * 其中 InternetAddress 的三个参数分别为: 邮箱, 显示的昵称(只用于显示, 没有特别的要求), 昵称的字符集编码
     */
    message.setFrom(new InternetAddress(from, "XXX", "UTF-8"));

    /**
     * 3，设置收件人
     * To收件人   CC 抄送  BCC密送
     */
    message.setRecipient(MimeMessage.RecipientType.TO,new InternetAddress(to, "", "UTF-8"));
    message.addRecipient(MimeMessage.RecipientType.TO,new InternetAddress(to, "", "UTF-8"));

    /**
     * 4，设置标题
     */
    message.setSubject("报表","UTF-8");

    /**
     * 5，组织数据
     */
    Workbook xlsFile = new HSSFWorkbook(); // create a workbook
    CreationHelper helper = xlsFile.getCreationHelper();
      
    Sheet sheet1 = xlsFile.createSheet("title"); // add a sheet to your workbook
    org.apache.poi.ss.usermodel.Row row1 = sheet1.createRow((short)0);
    sheet1.setColumnWidth(0, 25 * 256);
    sheet1.setColumnWidth(1, 30 * 256);
    row1.createCell(0).setCellValue(helper.createRichTextString("cell0"));
    row1.createCell(1).setCellValue(helper.createRichTextString("cell1"));
    row1.createCell(2).setCellValue(helper.createRichTextString("cell2"));
    
    ByteArrayOutputStream bos = new ByteArrayOutputStream();
    xlsFile.write(bos); // write excel data to a byte array
    bos.close();
    DataSource fds = new ByteArrayDataSource(bos.toByteArray(), "application/vnd.ms-excel");

    MimeBodyPart mbp1 = new MimeBodyPart();
    mbp1.setText("Everything will be fine.");

    MimeBodyPart mbp2 = new MimeBodyPart();
    mbp2.setDataHandler(new DataHandler(fds));
    mbp2.setFileName("report.xls");

    Multipart mp = new MimeMultipart();
    mp.addBodyPart(mbp1);
    mp.addBodyPart(mbp2);
    message.setContent(mp);

    /**
     * 6，保存邮件并发送
     */
    message.saveChanges();
    Transport transport = session.getTransport("smtp");
    transport.connect(smtpServer, from, authoCode);
    transport.sendMessage(message,message.getAllRecipients());
    transport.close();

} catch (MessagingException e) {
    e.printStackTrace();
} catch (UnsupportedEncodingException e) {
    e.printStackTrace();
}

需要使用到的pom依赖


<dependency>
    <groupId>javax.mail</groupId>
    <artifactId>mail</artifactId>
    <version>1.4.7</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>

转载于:https://www.cnblogs.com/wjf0/p/9440775.html