public void downloadExcel(){ HttpServletRequest request = ServletActionContext.getRequest(); HttpServletResponse response=ServletActionContext.getResponse(); BufferedInputStream in = null; BufferedOutputStream out = null; try { response.setContentType("text/html;charset=UTF-8"); request.setCharacterEncoding("UTF-8"); URL url = CommonTouristAction.class.getResource(""); String path = url.getPath().toString().replace("WEB-INF/classes/.*", ""); String path1[] = path.split("WEB-INF/classes/"); path = path1[0] + "model/xls/commonTouristModel.xls"; String fileName =URLEncoder.encode("常用旅客信息导入模板.xls", "UTF-8") ; File f = new File(path); response.setContentType("application/x-excel"); response.setCharacterEncoding("UTF-8"); response.setHeader("Content-Disposition", "attachment; filename="+fileName); response.setHeader("Content-Length",String.valueOf(f.length())); in = new BufferedInputStream(new FileInputStream(f)); out = new BufferedOutputStream(response.getOutputStream()); byte[] data = new byte[1024]; int len = 0; while (-1 != (len=in.read(data, 0, data.length))) { out.write(data, 0, len); } } catch (Exception e) { logger.error("下载模版异常:",e); } finally { if (in != null) { try { in.close(); } catch (IOException e) { logger.error("下载模版异常:",e); } } if (out != null) { try { out.close(); } catch (IOException e) { logger.error("下载模版异常:",e); } } } }
java ssh 下载excel,ssh下载excel文件
最新推荐文章于 2022-12-15 23:24:00 发布