freemarker导出excle

以下只不过是自己一个笔记而已，不喜勿喷！

1.maven中引入jar包

    <dependency>
        <groupId>org.freemarker</groupId>
        <artifactId>freemarker</artifactId>
        <version>2.3.23</version>
    </dependency>

2.建一个excle文件，设置好格式
将其另存为xml格式的文件

3.使用xml格式化工具格式化文件

4.在项目resources目录下创建template文件夹用于存放模版文件，将格式化后的xml文件复制到template文件夹下并改为.ftl格式

修改ftl文件，指定输出的sheet名称

  <#assign imap="学生表"> 
  <Worksheet ss:Name="${imap}"> 

遍历数据

 <#list list as item>
      <Row>
        <Cell ss:StyleID="s50">
          <Data ss:Type="Number">${item.id}</Data>
        </Cell>
        <Cell ss:StyleID="s50">
          <Data ss:Type="String">${item.name}</Data>
        </Cell>
        <Cell ss:StyleID="s50">
          <Data ss:Type="Number">${item.age}</Data>
        </Cell>
        <Cell ss:StyleID="s50">
          <Data ss:Type="String">${item.sex}</Data>
        </Cell>
        <Cell ss:StyleID="s50">
          <Data ss:Type="String">${item.content}</Data>
        </Cell>
      </Row>
      </#list>

5.创建导出工具类ExportExcel

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Writer;
import java.util.List;
import java.util.Map;

import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
import freemarker.template.TemplateExceptionHandler;
/**
 * @ClassName: ExportExcel
 * @Description:freemarker导出execle工具类
 * @author: Administrator
 * @version V 1.0
 * @date: 2017年4月22日 下午4:16:29
 */
public class ExportExcel {

    private static Configuration configuration;
    private static Template  template;

    /**
     * @Title: export   
     * @Description: 导出excle
     * @author: szc 
     * @param <E>
     * @param templatePath 模版所在路径
     * @param dataMap   导出数据
     * @param templateName 模版名称
     * @param fielName 导出文件的名称
     * @date:   2017年4月22日 下午4:47:34   
     * @since V 1.0
     */
    public static <E> boolean export(String templatePath, Map<String, List<E>> dataMap, String templateName, String fielName) {
        try {
            configuration = new Configuration(Configuration.VERSION_2_3_23);
            configuration.setDefaultEncoding("UTF-8");
            configuration.setDirectoryForTemplateLoading(new File(templatePath));
            configuration.setTemplateExceptionHandler(TemplateExceptionHandler.RETHROW_HANDLER);
            template = configuration.getTemplate(templateName);
            //直接导出到固定目录
            Writer writer=new FileWriter(fielName);
//如果是web项目中的导出，需要将其以流的方式写出,未测试
/*Writer writer=new BufferedWriter(new OutputStreamWriter(new   FileOutputStream(fielName), Charset.forName("UTF-8")));*/

            template.process(dataMap, writer);
            writer.flush();
            writer.close();
            return true;
        } catch (IOException e) {
            e.printStackTrace();
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        return false;
    }
}

6.创建要导出的student实体类

package com.cn.mybatisDemo.util;

public class Student {
    private int id;
    private String name;
    private int age;
    private String sex;
    private String content;

    public Student() {
    }

    public Student(int id, String name, int age, String sex, String content) {
        super();
        this.id = id;
        this.name = name;
        this.age = age;
        this.sex = sex;
        this.content = content;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

}

7.导出测试类

package com.cn.mybatisDemo.util;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class TestExecle {
    // 模版所在路径
    private static final String templatePath = "src/main/resources/template";
    // 模版名称
    private static final String templateName = "student.ftl";
    // 导出文件放置路径
    private static final String filePath = "C:\\Users\\Administrator\\Desktop\\";

    public static void main(String[] args) {
        TestExecle testExecle = new TestExecle();
        List<Student> data = testExecle.getData();
        Map<String, List<Student>> map = new HashMap<String, List<Student>>();
        map.put("list", data);
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd hh-mm-ss");

        // 导出的文件名称
        StringBuffer fileName = new StringBuffer();
        fileName.append(filePath).append(format.format(new Date())).append("学生表.xls");

        ExportExcel.export(templatePath, map, templateName, fileName.toString());

    }

    public List<Student> getData() {
        List<Student> list = new ArrayList<Student>();
        for (int i = 1; i <= 50; i++) {
            Student student;
            if (i % 2 == 0) {
                student = new Student(i, "张萨博" + i, i + 1, "男", "男士");
            } else {
                student = new Student(i, "王娜" + i, i + 2, "女", "女士");
            }
            list.add(student);
        }
        return list;
    }
}