根据excel模板导出excel

		String sql = ""; //需要导出的内容SQL，导出字段名一定要与下图中的字段名对应
		
		//将等于null的值设为空，否则会报空指针
		List<Map<String,Object>>   maps1=jdbcTemplate.queryForList(sql);
		for(String s:maps1.get(0).keySet()){
	        	if ( maps1.get(0).get(s)==null) {
	        		maps1.get(0).put(s, "");
				}
	      }
		
		//将需要替换的类型值替换掉
		String offerBjUnit = (String)maps1.get(0).get("offerBjUnit");
		if(StringUtils.isNotBlank(offerBjUnit)) {
			String unitSql = "select name from table where id='111111' and code='"+offerBjUnit+"'";
			String name = jdbcTemplate.queryForObject(unitSql, String.class); 
			maps1.get(0).put("offerBjUnit",name);
		}
		
		TemplateExportParams params = new TemplateExportParams(
 	            "export/template/quotationExport.xls","报价单",0);
		modelMap.put(TemplateExcelConstants.FILE_NAME, "报价单"); //文件名
        modelMap.put(TemplateExcelConstants.PARAMS, params);//参数
        modelMap.put(TemplateExcelConstants.MAP_DATA, maps1.get(0));//数据