制作excle报盘模板

最新推荐文章于 2020-03-26 10:27:48 发布

持.之.以.恒

最新推荐文章于 2020-03-26 10:27:48 发布

阅读量819

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/zl834205311/article/details/56014734

版权

java 专栏收录该内容

38 篇文章 0 订阅

订阅专栏

前端jsp(简略):

<!-- 报盘模板下载 -->
						<a href="${base!}/get_template.do" style="cursor: point;text-decoration: underline;font-size: 14px;display: inline-block;float: right;margin-right: 10px;color: #007bbf;background-color:#f5fafc;line-height:35px;">模板下载</a>

servlet:

@RequestMapping("get_template.html")
	public void downloadTemplate(HttpServletRequest request, HttpServletResponse response){
		OutputStream out = null;
		try {
			String path = request.getSession().getServletContext().getRealPath("/");
			String fileName = new String(("报盘模板.xls").getBytes("GBK"), "ISO8859_1");
			response.setContentType("application/vnd.ms-excel");
			response.setHeader("Content-disposition", "attachment;filename=\"" + fileName + "\"");
			out = response.getOutputStream();
			String filePath = path + "/WEB-INF/excelTemplate/pbpweb.xls";
			InputStream inputSteam =new FileInputStream(filePath);
			HSSFWorkbook wb = new HSSFWorkbook(inputSteam);
			inputSteam.close();
			wb.write(out);
			wb.close();
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			try {
				out.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}

报盘模板存放位置：

项目根目录：