使用freemarker模板导出word文档,用的比较多。这里也是采用的这种方式。
1 编辑一个word文件的模板,用于在程序中需要读入填充在模板中的数据先用字母代替,注意word版本为word2003或高于这个版本;
如:test.doc
2 把模板另存为xml文件;
如:test.xml
3 在xml中查找之前用字母代替的值 加上${} ,如${test} ${guojia},把文件名改为test.ftl;
4 在项目的WebContent目录下新建一个文件夹,把test.xml放进去;
5 编写代码;
package com.web.action;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts2.ServletActionContext;
import org.springframework.stereotype.Controller;
import com.opensymphony.xwork2.ActionSupport;
import freemarker.template.Configuration;
import freemarker.template.DefaultObjectWrapper;
import freemarker.template.Template;
@Controller
public class ExportAction extends ActionSupport{
//word模板
public static final String word_template="/test.ftl";
//存放模板的目录
public static final String template_path="/template";
//临时文件
public static final String word_temp="/temp.doc";
public String executeExport(){
HttpServletRequest request=ServletActionContext.getRequest();
HttpServletResponse response=ServletActionContext.getResponse();
try {
Map dataMap=new HashMap();
if(getData(request, response, dataMap)){
File previewFile=new File(request.getSession().getServletContext().getRealPath(word_temp));
InputStream is=new FileInputStream(previewFile);
response.reset();
response.setContentType("application/vnd.ms-word;charset=UTF-8");
response.setHeader("Content-Disposition","attachment; filename=export.doc");
OutputStream os=response.getOutputStream();
byte[] b=new byte[1024];
int len;
while((len=is.read(b))!=-1){
os.write(b, 0, len);
}
is.close();
os.flush();
os.close();
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public static Template configTemplate(HttpServletRequest request,String temp){
Template template=null;
try {
Configuration cfg=new Configuration();
ServletContext application=request.getSession().getServletContext();
System.out.println(application.getRealPath(template_path));
cfg.setDirectoryForTemplateLoading(new java.io.File(application.getRealPath(template_path)));
cfg.setObjectWrapper(new DefaultObjectWrapper());
template=cfg.getTemplate(temp,"utf-8");
} catch (Exception e) {
e.printStackTrace();
}
return template;
}
public static void toPreview(HttpServletRequest request,String temp,Map, ?> root){
try {
String previewPath=request.getSession().getServletContext().getRealPath("")+word_temp;
Template tmplate=configTemplate(request, temp);
FileOutputStream fis=new FileOutputStream(previewPath);
Writer out=new OutputStreamWriter(fis,"utf-8");
tmplate.process(root, out);
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public boolean getData(HttpServletRequest request,HttpServletResponse response,Map dataMap){
dataMap.put("test", "测试");
dataMap.put("guojia", "中国");
dataMap.put("shoudu", "首都");
toPreview(request, word_template, dataMap);
return true;
}
}
6 我用的struts2,executeExport为处理请求的方法,之前返回值我写的是任意字符串,不影响结果但是抛出异常 java.lang.IllegalStateException,我把返回的字符串改成null,这个异常被解决了。呵呵 当然这是和导出无关的事情,只是在这个程序里遇到了这个问题。
7 导出结果:
原文:http://blog.csdn.net/liangwenmail/article/details/48011025