freemarker导出excel

import freemarker.template.Configuration;
import freemarker.template.Template;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.*;
import java.util.*;

public class ExcelExporter {
    public static void exportToExcel(Map<String, Object> dataModel, String templateName, String outputFilePath) throws Exception {
        // 初始化FreeMarker配置
        Configuration cfg = new Configuration(Configuration.VERSION_2_3_30);
        cfg.setClassForTemplateLoading(ExcelExporter.class, "/templates");

        // 获取模板
        Template template = cfg.getTemplate(templateName);

        // 创建Excel工作簿和工作表
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("Data");

        // 使用FreeMarker模板生成Excel内容
        StringWriter stringWriter = new StringWriter();
        template.process(dataModel, stringWriter);
        String content = stringWriter.toString();

        // 解析内容并填充到Excel中（这里简化处理，实际情况可能需要更复杂的逻辑）
        // ...

        // 写入文件
        try (FileOutputStream fileOut = new FileOutputStream(outputFilePath)) {
            workbook.write(fileOut);
        }
    }

    public static void main(String[] args) {
        try {
            Map<String, Object> dataModel = new HashMap<>();
            // 填充数据模型
            // ...

            exportToExcel(dataModel, "exportTemplate.ftl", "output.xlsx");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}