{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["学校-部门人员导入模板"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"学校-部门人员导入模板","index":0,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,1,1,2],[1,3,1,7],[1,8,1,16]],"flags":["formulas_cached_only"]}
["导入须知DepartmentalOfficerv1.0\n1.不能在本excel表中对字段名称进行增加、删除、修改；\n2.初次导入时红色为必填字段，包括人员姓名，部门信息（部门名称/部门编码可二选一）；账号信息（红色为必填，蓝色为选填，不可为空）；\n3.部门编码：多部门编码用英文的“,”隔开；\n4.部门名称：多部门用英文“,”隔开；从最上级部门开始，例如“组织部-组织1部”；\n5.手机号：手机号初次导入后，管理员无法再进行编辑修改，用户可以自己进行修改；\n6.账号导入方式支持自定义账号，如账号已存在，则添加此已存在用户到学校中；若账号不存在，则为新增用户；\n7.证件号：证件号输入如果出现被转义，可以在首尾输入空格防止被转义;\n8.证件类型：请填写“身份证、护照、香港通行证、澳门通行证、台湾通行证“;\n9.日期：请填写如“20230115”格式。"]
["用户信息","部门信息",null,"账号信息(均可作为登录账号)",{"$nulls":4},"其他字段"]
["姓名","部门编码","部门名称","手机号","账号","教师证号","师训号","证件号","证件类型","出生日期","修改账号","用户类型","性别","员工邮箱","员工工号","职位","备注"]
["张xx","22xxxxxx","财务部-财务一部","131xxxx6868",{"$nulls":4},"身份证","20220101",null,"教师","男",null,"G1xxxx2222"]