基础知识储备-freemarker自动解析ftl生成邮件表格 并且自动生成excel附件

邮件content是个表格，是从ftl文件用freemarker生成后抽出来的页面放到邮件content里，然后用poi生成excel作为附件发送

需要引入的依赖
<dependency>
    <groupId>org.freemarker</groupId>
    <artifactId>freemarker</artifactId>
</dependency>
<!--email-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-mail</artifactId>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.10-FINAL</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.10-FINAL</version>
</dependency>

commonService类
@Autowired
private JavaMailSender mailSender;

/**
 * 发送邮件，带附件
 */
@Override
public void sendHtmlMail(String[] to, String from, String subject, String content, byte[] attachmentData,
                         String attachmentName) throws UnsupportedEncodingException, MessagingException {
    MimeMessage message = mailSender.createMimeMessage();
    MimeMessageHelper helper = new MimeMessageHelper(message, true, "UTF-8");
    helper.setFrom(from);
    helper.setTo(to);
    helper.setSubject(subject);
    helper.setText(content, true);
    DataSource dataSource = new ByteArrayDataSource(attachmentData, "application/octet-stream");
    helper.addAttachment(MimeUtility.encodeWord(attachmentName, "utf-8", "B"), dataSource);
    //发送邮件
    mailSender.send(message);
}

/**
 * 解析模板数据
 */
@Override
public String parsingFtlFile(Map<String, Object> data, String templateName, String templatePath)
        throws IOException, TemplateException {
    Configuration cfg = new Configuration(Configuration.VERSION_2_3_25);
    TemplateLoader daf = new ClassTemplateLoader(CommonServiceImpl.class, templatePath);
    cfg.setTemplateLoader(daf);
    Template template = cfg.getTemplate(templateName);
    StringWriter stringWriter = new StringWriter();
    BufferedWriter writer = new BufferedWriter(stringWriter);
    template.process(data, writer);
    return stringWriter.toString();
}

 

这是我自己封装的两个方法，下面是应用：

Map<String, Object> data = new HashMap<>();
data.put("zhzsEmailNewlyDataOut", zhzsEmailNewlyDataOut);
data.put("startDate", statisQueryIn.getStartDate());
data.put("endDate", statisQueryIn.g