1.所需的包:
jxls-core-1.0.6.jar
commons-jexl-2.1.1.jar
2.java 代码:
Map<String, Object> results = new HashMap<String, Object>();
OutputStream out = null;
InputStream ins = null;
try{
List<Map<String,String>> resultslist = new ArrayList<Map<String,String>>();
//组装数据
Map<String, String> res = new HashMap<String, String>();
res.put("rowNum", rowNum);
resultslist.add(res);
//数据组装
results.put("resultslist", resultslist);
//获取模版
String path = getServlet().getServletContext().getRealPath("/");
String templateFilePath = path + "resource/template.xls";
String filename = DateUtil.convertDateToString(new Date(), "yyyyMMddHHmmss")+".xls";
String filePath = ResourceUtil.getKmssConfigString("kmss.resource.path&#