{"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":"醫師電話"}]