Java POI实现导出Excel表 直接在浏览器下载

借鉴

(不能使用ajax)

响应代码

     HSSFWorkbook workbook=null;//文件
	String filePath="文件名.xls";
	 response.reset();//清除buffer缓存
         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
         response.setHeader("Content-Disposition", "attachment; filename="+ new String(filePath.getBytes("UTF-8"), "ISO-8859-1"));// 定义文件名  
         response.setHeader("Pragma", "no-cache");  
         response.setHeader("Cache-Control", "no-cache");  
         response.setHeader("Expires", " 0");  
         
         try {
			OutputStream output;
			try {
				output=response.getOutputStream();
				BufferedOutputStream bufferOutput =new BufferedOutputStream(output);
				bufferOutput.flush();
				workbook.write(bufferOutput);
				bufferOutput.close();
			} catch (Exception e) {
			}
		} catch (Exception e) {
		}

  创建文件

借鉴

posted @ 2021-10-09 14:01  晓*雨  阅读(744)  评论(0)    收藏  举报