POI 导出Excel表格 输出数据流

 

 FileOutputStream fileOut = new FileOutputStream("E:/workbook.xls");    
 workbook.write(fileOut);    
 fileOut.close();

 

 pName="*****";   
 response.reset();   
 response.setContentType("application/x-msdownload");   
 response.setHeader("Content-Disposition","attachment;filename="+new String(pName.getBytes("gb2312"),"ISO-8859-1")+".xls");   
 ServletOutputStream outStream=null;   
	  
try{   
	outStream = response.getOutputStream();   
	wb.write(outStream);   
    }catch(Exception e)   
	    {   
	     e.printStackTrace();   
	    }finally{   
	        outStream.close();   
	    }   

 

{
HSSFWorkbook workbook = ExportToExcel.userExportToExcel(list);
			
			HttpServletResponse response = ServletActionContext.getResponse();

	    	String fileName = "***.xls";
	    	
		    response.setContentType("application/octet-stream");
		    response.setHeader("name", fileName);
    		response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
			response.setHeader("Pragma", "public");
			response.setDateHeader("Expires", 0);
			response.setHeader("Content-disposition","attachment; filename=\""+URLEncoder.encode(fileName, "UTF-8")+ "\"");

			workbook.write(response.getOutputStream()); // 输出流控制workbook

			response.getOutputStream().flush();

			response.getOutputStream().close();
			
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

 

 

评论

1 楼 18335864773 2017-06-09  

最近了解到另一种方法。用pageoffice生成excel。不用下载即可在网页上查看编辑保存。与poi相比，代码简洁高效。有良好的兼容性。支持各种浏览器，以及office版本和wps