JXLS使用

最新推荐文章于 2024-08-16 11:30:00 发布

weixin_30908649

最新推荐文章于 2024-08-16 11:30:00 发布

阅读量1.2k

点赞数

文章标签：人工智能操作系统 c#

原文链接：http://www.cnblogs.com/douhuan/p/11130270.html

版权

public void searchexport(String idcards, HttpServletRequest request, HttpServletResponse response,String id) {
　　OutputStream out = null;
　　Map map = new HashMap();
　　XLSTransformer transformer = new XLSTransformer();
　　InputStream is = UserInfoController.class.getClassLoader().getResourceAsStream("template" + File.separator + "excel" +File.separator + "export" + File.separator + "search.xls");
　　String downloadFileName = "";
　　String fileName = "成绩表";
　　List list = null;
　　try {
　　　　map = testPaperService.searchexport(idcards,id);
　　} catch(QueryException e1) {
　　　　e1.printStackTrace();
　　}
　　map.put("title", fileName);
　　map.put("date", list);
try {
　　downloadFileName = new String(fileName.getBytes("gbk"), "ISO-8859-1");
　　response.reset();
　　response.setContentType("application/octet-stream; charset=utf-8");
　　response.setHeader("Content-Disposition", "attachment;filename=\"" + downloadFileName + ".xls\"");

　　out = response.getOutputStream()

　　org.apache.poi.ss.usermodel.Workbook workbook = transformer.transformXLS(is, map);
　　workbook.write(out);
　　} catch(Exception e) {
　　e.printStackTrace();
　　}
}

转载于:https://www.cnblogs.com/douhuan/p/11130270.html