这里用的是poi相关jar包以及freemarker插值技术实现,poi相关jar包这里不再述说
1,编辑word并保存为xml
其中需要动态输出的内容使用${xxx}代替,xxx是你的java类属性值,如:年龄:${age}
打开的xml要看看是否为途中${}的样式,如果被wold分割了,需要自己了解wold xml格式并去修改
2,把xml后缀改为ftl文件
![](https://i-blog.csdnimg.cn/blog_migrate/5615e9e606677c1924936c15a49d7601.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/7445cd7901c0ac50f0808fcdcaa54fd0.gif)
$(function() {
//导出
$("#exportWordData").click(function() {
var id = $("input[name='id']").val();
// alert(id);
var url = __ctx+'/yjsqsgyrb/yjsqsgyrb/yjsqsgyrb/exportWordxml.ht?id='+id;
var userAgent = navigator.userAgent; //取得浏览器的userAgent字符串
if (userAgent.indexOf("compatible") > -1 && userAgent.indexOf("MSIE") > -1) {//判断是否IE浏览器
window.location.href(url);
}else{
window.open(url,"xxx调度日报_");
}
});
});
![](https://i-blog.csdnimg.cn/blog_migrate/8a73f26763e6ca119b2315f6f003492e.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/ac160d588924257f577b7f4b1e568fbe.gif)
@RequestMapping("exportWordxml")
public void exportWordxml(HttpServletRequest request, HttpServletResponse response) throws Exception {
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
Map<String, Object> rootMap = new HashMap<String, Object>();
String id = RequestUtil.getString(request, "id");
Yjsqsgyrb yjbb = new Yjsqsgyrb();
yjbb = (Yjsqsgyrb) yjsqsgyrbService.getById(Long.valueOf(Long.parseLong(id)));
Gson gson = new Gson();
String json = gson.toJson(yjbb);
rootMap = gson.fromJson(json, rootMap.getClass());
String name = "xxx日报_" + df.format(new Date()) + ".doc";
// 设置MIMI类型,默认的是text/hmtl
response.setHeader("Content-Type", "application/msword");
// 解决中文乱码,以及设置生成的文档名
response.setHeader("Content-Disposition", "attachment;filename=" + new String(name.getBytes("utf-8"), "ISO8859-1"));
// 取得当前类所在的目录
String filePath = FileUtil.getRootPath() + File.separator + "commons" + File.separator + "template" + File.separator + "yjdlbb" + File.separator;
Configuration cfg = new Configuration();
cfg.setDirectoryForTemplateLoading(new File(filePath));
// 这里不设置编码的话,即是成功了有时也打不开文件,因为乱码
Template temp = cfg.getTemplate("myxml.ftl", "utf-8");
PrintWriter pw = response.getWriter();
/* 合并数据模型和模版 */
temp.process(rootMap, pw);
pw.flush();
pw.close();
}
其中导入的类
import com.google.gson.Gson;
import freemarker.template.Configuration;
import freemarker.template.Template;
若需要修改其中的值,可以直接修改map中的json即可,比如同比需要判断数字大于零在前面添加增长,小于零则在前面添加减少
![](https://i-blog.csdnimg.cn/blog_migrate/b470cb68d40431f1eced4329e578b00d.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/29c959969ee86bdec4583768ff6420bd.gif)
Map<String, Object> rootMap = new HashMap<String, Object>();
String id = RequestUtil.getString(request, "id");
Yjsqsgyrb yjbb = new Yjsqsgyrb();
yjbb = (Yjsqsgyrb) yjsqsgyrbService.getById(Long.valueOf(Long.parseLong(id)));
Gson gson = new Gson();
String json = gson.toJson(yjbb);
rootMap = gson.fromJson(json, rootMap.getClass());
Object object = rootMap.get("qstdzgfhhb");
if (object!=null) {
Double double1 = (Double) object;
if (double1!=null&&double1>0) {
rootMap.put("qstdzgfhhb", "增加"+double1);
}else if (double1!=null&&double1<0) {
rootMap.put("qstdzgfhhb", "减少"+Math.abs(double1));
}
// System.out.println("-----------"+double1);
}
![](https://i-blog.csdnimg.cn/blog_migrate/3773450f263d839d66ecf3745bef6056.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/b69aebce16bb77c784a438886a8b3b38.gif)
/**
* @param rootMap
* void 调用 rootMap =yjsqsgyrbService.handleVar(rootMap);
*
*/
public Map<String, Object> handleVar(Map<String, Object> rootMap) {
java.util.List<String> vars = new java.util.ArrayList<String>();
vars.add("qstdzgfhhb");
vars.add("hbsrzj");
vars.add("rydlhb");
vars.add("yljydltb");
vars.add("nljydltb");
for (String key : vars) {
Object object = rootMap.get(key);
if (object != null) {
Double double1 = (Double) object;
if (double1 != null && double1 > 0) {
rootMap.put(key, "增加" + double1);
} else if (double1 != null && double1 < 0) {
rootMap.put(key, "减少" + Math.abs(double1));
}
}
}
return rootMap;
}