先上代码
java code:
<pre name="code" class="java">package cn.export.util;
import java.io.FileInputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jxls.transformer.XLSTransformer;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
/*** 导出文件util* @author*/
public class ExportUtil {@SuppressWarnings("unchecked")public static void exportData(HttpServletRequest req, HttpServletResponse resp, List results,String fileName, String year,String quarter, String filePath) throws Exception{FileInputStream fis = null;ServletOutputStream os = null;XLSTransformer transformer = new XLSTransformer();Map params = new HashMap();params.put("year", year);params.put("quarter", quarter);params.put("results", results);fis = new FileInputStream(filePath);resp.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xls");resp.setContentType("application/vnd.ms-excel;charset=gbk");resp.setHeader("Location", URLEncoder.encode(fileName,"UTF-8") + ".xls");HSSFWorkbook wb = transformer.transformXLS(fis, params);os = resp.getOutputStream();wb.write(os);os.flush();os.close();fis.close();}
}
java code：
package cn.export.com;
import java.io.IOException;
import java.net.URL;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.export.util.ExportUtil;
public class ExportServlet extends HttpServlet{@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {this.doPost(req, resp);}@SuppressWarnings("unchecked")@Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp){try {String fileName = "服装销售统计";List results = new ArrayList();for(int i = 0; i < 3; i++){Map resMap = new HashMap();resMap.put("id", i);resMap.put("name", "女装"+i);resMap.put("area", "广州");resMap.put("traffic", "高铁");resMap.put("level", "A");resMap.put("time", "2014/09/19");resMap.put("operator", "张三");resMap.put("remark", "销售良好");results.add(i, resMap);}URL url = this.getClass().getClassLoader().getResource("");String filePath = url.getPath() + "doc/fz.xls";ExportUtil.exportData(req, resp, results, fileName, "2014", "2", filePath);} catch (Exception e) {}finally{try {} catch (Exception e) {}}}
}
所需jar包：
所需jar包下载： 点击这里 (该功能单独测试，没有和其他框架整合)
Excel表模板格式：
（注：excel获取数据的方式： ${results.get("key")} ,key为上面代码中map的key）
结果显示：
