java 实现POI 导出Excel

1 . maven中添加一下依赖 

注：1.如果你不是用maven，而是手动导入jar包，需要自己去下载或者联系我

       2.一定不能用 $.ajax来请求这边没有回调函数 而是直接输出文件流

 <dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>

2. 复制以下方法到controller中

    /**
	 * 导出报表
	 * @return
	 */
	@RequestMapping(value = "/export")
	public void export(HttpServletRequest request,HttpServletResponse response,Integer voteId) throws Exception {
		Map<String,Object> map=new HashMap<>();
		map.put("voteId",voteId);
		List<AppTpEnrollDO> list =appTpEnrollService.list(map);
		if(list!=null && list.size()>0){
			//excel标题
			String[] title = {"选手名字","编号","电话","报名时间","普通票数"};
			//excel文件名
			String fileName = "统计表.xls";
			//sheet名
			String sheetName = "统计表";
			String [][] content = new String[list.size()][];
			for (int i = 0; i < list.size(); i++) {
				content[i] = new String[title.length];
				AppTpEnrollDO obj = list.get(i);
				content[i][0] = obj.getName();
				content[i][1] = obj.getId().toString();
				content[i][2] = obj.getPhone();
				content[i][3] = obj.getEnrollTime();
				content[i][4] = String.valueOf(obj.getOrdinaryNumber());
			}
			//创建HSSFWorkbook
			HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook(sheetName, title, content, null);
			//响应到客户端
			try {
					this.setResponseHeader(response, fileName);
					OutputStream os = response.getOutputStream();
					wb.write(os);
					os.flush();
					os.close();
				} catch (Exception e) {
       				e.printStackTrace();
 				}
			}
		}

    //发送响应流方法
	public void setResponseHeader(HttpServletResponse response, String fileName) {
		try {
			try {
				fileName = new String(fileName.getBytes(),"ISO8859-1");
			} catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			response.setContentType("application/octet-stream;charset=ISO8859-1");
			response.setHeader("Content-Disposition", "attachment;filename="+ fileName);
			response.addHeader("Pargam", "no-cache");
			response.addHeader("Cache-Control", "no-cache");
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

  注意：（一些类需要改成自己的 如 ：1 AppTpEnrollDO 改成自己的实体类 2 appTpEnrollService 换成自己的接口）

  这样就实现了Excel导出

 联系方式：

 QQ：2270084470

 微信：m2270084470