XLS《导入模板表》

导入模板表 "CET学籍信息模板" "特别说明:

1、不可改变本表格的行列结构,否则将会导入失败!

2、必须按照规格说明的格式填写.

3、可以多次导入,重复的考生信息会被新数据更新覆盖.

4、保存的excel文件名称可以自定. "顺序号 (方便计数)","报名学校及校区编号 (5位学校代码+1位校区代码)","不可以超过16个汉字(32个字符) 中文姓和名中间不要空格 外文姓与名中间留一个空格","1-男2-女","≤20位","1-中华人民共和国居民身份证 2-台湾居民往来大陆通行证 3-港澳居民来往内地通行证 4-护照 5-香港身份证 6-澳门身份证 7-港澳居民居住证 8-台湾居民居住证 ","身份证必须是15位或18位,否则请选其他","10-研究生 20-本科 30-专科","1位数","2位数字,入学年份的后2位","2位数字 例:二年级填02,或15","院系名称 请注意前后一致","专业名称 请注意前后一致","自然班号 请注意前后一致","学籍所在学校编号 (5位学校代码)当报名学校与学籍所在校一致时,该栏目可为空","如考生入场时使用其他证件,须在该栏目中填写相应证件号码,否则可为空" "序号","校区代码","姓名","性别","学号","证件类型","证件号码","学历","学制","入学年份","年级","院系","专业","班级","学籍所在校代码","身份证件备注" 样例数据表 "CET学籍信息模板 (样例,不要使用本sheet) "特别说明:

1、不可改变本表格的行列结构,否则将会导入失败!

2、必须按照规格说明的格式填写.

3、可以多次导入,重复的考生信息会被新数据更新覆盖.

4、保存的excel文件名称可以自定. "顺序号 (方便计数)","报名学校及校区编号 (5位学校代码+1位校区代码)","不可以超过16个汉字(32个字符) 中文姓和名中间不要空格 外文姓与名中间留一个空格","1-男2-女","≤20位","1-中华人民共和国居民身份证 2-台湾居民往来大陆通行证 3-港澳居民来往内地通行证 4-护照 5-香港身份证 6-澳门身份证 7-港澳居民居住证 8-台湾居民居住证 ","身份证必须是15位或18位,否则请选其他","10-研究生 20-本科 30-专科","1位数","2位数字,入学年份的后2位","2位数字 例:二年级填02,或15","院系名称 请注意前后一致","专业名称 请注意前后一致","自然班号 请注意前后一致","学籍所在学校编号 (5位学校代码)当报名学校与学籍所在校一致时,该栏目可为空","如考生入场时使用其他证件,须在该栏目中填写相应证件号码,否则可为空" "序号","校区代码","姓名","性别","学号","证件类型","证件号码","学历","学制","入学年份","年级","院系","专业","班级","学籍所在校代码","身份证件备注" "1","990011","张三","1","789098378","1","110109199509087631","20","4","14","02","机械工程","锻造","901", "2","990011","爱心・觉罗","2","678999875","2","7837836G889","10","3","15","01","文学院","英国语言文学","土021","99002" "3","990011","TOM SMITH","1","78239498762","3","H87767234","10","2","15","01","文学院","国际汉语","011机2",