{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["学生列表","班级名单","学生详细信息"],"not_rendered":{"images":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"学生列表","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[1,2,2,3],[1,4,1,11],[2,4,2,11],[6,12,8,16]]}
[]
[null,null,"学生列表",null,"转到班级花名册"]
[{"$nulls":4},"转到学生详细信息"]
[null,null,"学生姓名","电子邮件","住宅电话","移动电话","出生日期","紧急联系人","紧急联系电话","医师","医师电话","  "]
[null,null,"姓名 1","电子邮件地址","住宅电话","移动电话","日期","联系人 1","紧急联系电话","医师 1","医师电话"]
[null,null,"姓名 2","电子邮件地址","住宅电话","移动电话","日期","联系人 2","紧急联系电话","医师 2","医师电话"]
[null,null,"姓名 3","电子邮件地址","住宅电话","移动电话","日期","联系人 3","紧急联系电话","医师 3","医师电话",null,"提示：若要添加更多的学生，请在表格的最后一个单元格中按 Tab 键。"]
[null,null,"姓名 4","电子邮件地址","住宅电话","移动电话","日期","联系人 4","紧急联系电话","医师 4","医师电话"]

{"sheet":"班级名单","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[1,2,2,2],[1,3,2,3],[1,4,1,6],[2,4,2,6]]}
[]
[null,null,"班级花名册","图形设计学院","转到学生列表"]
[{"$nulls":4},"转到学生详细信息"]
[null,null,"课程","课程名称","开始日期","日期"]
[null,null,"讲师","讲师 1","结束日期","日期"]
[null,null,"已注册的学生数",{"$f":"COUNTA(学生名单[学生姓名])","v":4}]
[]
[null,null,"学生姓名","电子邮件","住宅电话","移动电话","  "]
[null,null,"姓名 1",{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],2),\"\")","v":"电子邮件地址"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],3),\"\")","v":"住宅电话"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],4),\"\")","v":"移动电话"}]
[null,null,"姓名 2",{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],2),\"\")","v":"电子邮件地址"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],3),\"\")","v":"住宅电话"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],4),\"\")","v":"移动电话"}]
[null,null,"姓名 3",{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],2),\"\")","v":"电子邮件地址"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],3),\"\")","v":"住宅电话"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],4),\"\")","v":"移动电话"}]
[null,null,"姓名 4",{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],2),\"\")","v":"电子邮件地址"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],3),\"\")","v":"住宅电话"},{"$f":"IFERROR(VLOOKUP(学生名单[[#This Row],[学生姓名]],学生[],4),\"\")","v":"移动电话"}]

{"sheet":"学生详细信息","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[1,2,2,2],[1,3,1,4],[2,3,2,4],[3,2,3,3]]}
[]
[null,null,"学生详细信息","转到学生列表"]
[{"$nulls":3},"转到班级花名册"]
[null,null,"提示：从单元格 D5 的下拉列表中选择一个学生来更新学生详细信息"]
[null,null,"学生姓名","姓名 1"]
[null,null,"电子邮件",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],2,FALSE),\"\")","v":"电子邮件地址"}]
[null,null,"住宅电话",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],3,FALSE),\"\")","v":"住宅电话"}]
[null,null,"移动电话",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],4,FALSE),\"\")","v":"移动电话"}]
[null,null,"出生日期",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],5,FALSE),\"\")","v":"日期"}]
[null,null,"紧急联系人",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],6,FALSE),\"\")","v":"联系人 1"}]
[null,null,"紧急联系电话",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],7,FALSE),\"\")","v":"紧急联系电话"}]
[null,null,"医师",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],8,FALSE),\"\")","v":"医师 1"}]
[null,null,"医师电话",{"$f":"IFERROR(VLOOKUP(学生姓名,学生[],9,FALSE),\"\")","v":"医师电话"}]