{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["本专科ZZSG学费补偿贷款代偿资助名单","代码表","错误信息"],"not_rendered":{"macros":1,"external_links":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"本专科ZZSG学费补偿贷款代偿资助名单","index":0,"n_rows":9,"n_cols":109,"rows_kept":9,"merged":[[2,2,2,6]],"flags":["formulas_cached_only"]}
["checkName","checkSfzjh","checkYesNo","checkBclb","checkDklb","checkDkNum","checkDkNum","checkPzje","checkNum1,6,2","checkDateNecessary","checkLen0,1,50"]
[9]
["注意：请勿调整模板的格式以及各列的顺序等，否则会造成导入失败",null,"  本专科ZZSG学费补偿贷款代偿资助名单"]
[]
["1","1","1","1","1","1","1","1","1","1","1"]
["xm","sfzjh",{"$nulls":3},"zxdkBjje","zxdkLxje","pzje","sjje","fundDate","bz",{"$nulls":95},"sfdxs","bcdclb","zxdklb"]
["学生姓名","身份证件号","是否定向生","补偿代偿类别","助学贷款类别","助学贷款本金金额","助学贷款利息金额","批准补偿金额","实际缴纳学费金额","发放日期","备注"]
["必须为汉字（可以包含·和大小写字母），长度大于等于1，且不超过20个汉字，例如“张三”或者“张san”必填项","填写学生居民身份证件号，长度必须为18位，例如“140602199907061024”（最后一位为字母X必须大写）必填项","填写学生是否为定向生，“是”或“否”可以填写，且仅能填写一个，必填项","填写学生选择的学费补偿贷款代偿类别，只能填“贷款代偿”、“学费补偿”，必填项","填写申请学生的助学贷款类别，如：“生源地信用助学贷款”“高校国家助学贷款”等,当补偿代偿类别为“贷款代偿”时为 必填项","填写学生助学贷款本金金额，如：“20000”，只能填写5位数以内整数及保留两位小数，且不大于80000，如果补偿代偿类别为“贷款代偿”则为必填项，“学费补偿”则是非必填项","填写学生助学贷款利息金额，如：“8000”，只能填写6位数以内整数及保留两位小数，如果补偿代偿类别为“贷款代偿”则为必填项，“学费补偿”则是非必填项","填写上级部门批准补偿金额，如：“20000”，只能填写5位数以内整数及保留两位小数，且不大于80000，必填项","填写学生的实际缴纳的学费金额，如：“8000”，只能填写6位数以内整数及保留两位小数，必填项","填写学生资助的发放时间，如：20120101，填写时间必须在当前时间之前，包括当日，必填项","备注，非必填项"]
[{"$nulls":3},"学费补偿",{"$nulls":4},"填的是学费不含住宿费","20250924"]

{"sheet":"代码表","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"flags":["formulas_cached_only"]}
["方法名","序号/说明","名称","类型",{"$nulls":3},"bzkZzsgSub"]
[{"$nulls":7},"FAILURE"]
["checkYesNo",1,"是","是",{"$nulls":3},"4144012574"]
["checkYesNo",0,"否","否"]
[]
[]
[]
["checkDklb",1,"高校国家助学贷款","贷款类型"]
["checkDklb",2,"生源地信用助学贷款","贷款类型"]
[]
[]
["checkBclb",2,"贷款代偿","代偿补偿类别"]
["checkBclb",1,"学费补偿","代偿补偿类别"]
[]
[]
["checkDklbT",0,null,"贷款类型（当补偿类别为贷款代偿时）"]

{"sheet":"错误信息","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}