{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["datos","pagos"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"datos","index":0,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["رقم الطالب","اسم الطالب (ة)","تاريخ الازدياد","تاريخ التسجيل","الجنس","المستوى","الفصل","التوقيت","المعلمة","Padre","تاريخ الانتهاء"]
[1,"القاضي محمد","2011-01-08","2021-09-01","ولد","الثاني",1,"10--12","لطيفة","القاضي عبدالعزيز","2021-09-01"]
[2,"القاضي نسرين","2005-11-26","2021-09-01","بنت","الثاني",1,"10--12","لطيفة","القاضي عبدالعزيز","2021-09-01"]
[3,"القاضي عبدالحق","2015-07-23","2021-09-01","ولد","التحضيري",1,"10--12","امال","القاضي عبدالعزيز","2021-09-01"]
[4,"ختوتي سفيان","2007-01-26","2021-09-01","ولد","الثالث",1,"12--14","لطيفة","ختوتي طارق","2021-09-01"]
[5,"ختوتي ادم","2009-09-08","2021-09-01","ولد","الثاني",1,"10--12","لطيفة","ختوتي طارق","2021-09-01"]
[6,"ختوتي انس","2015-10-10","2021-09-01","ولد","التحضيري",1,"10--12","امال","ختوتي طارق","2021-09-01"]
[7,"واعلي أشرف","2008-04-10","2021-09-01","ولد","الاول",1,"10--12","ليلى","واعلي عبدالسلام","2021-09-01"]
[8,"واعلي يوسف","2015-06-24","2021-09-01","ولد","التحضيري",1,"10--12","امال","واعلي عبدالسلام","2021-09-01"]
[9,"اقشار ليان","2014-04-01","2021-09-01","بنت","الاول",1,"10--12","ليلى","اقشار مصطفى","2021-09-01"]
[10,"بوكرمة ادم","2009-05-15","2021-09-01","ولد","الاول",2,"12--14","ليلى","مينة قندوسي","2021-09-01"]
[11,"بوكرمة ندى","2011-04-18","2021-09-04","بنت","الاول",2,"12--14","ليلى","مينة قندوسي","2021-09-04"]
[12,"بوكرمة أيوب","2016-01-21","2021-09-04","ولد","التحضيري",2,"12--14","امال","مينة قندوسي","2021-09-04"]
[13,"ختوتي زينب","2016-10-01","2021-09-11","بنت","التحضيري",1,"10--12","امال","ختوتي رشيد","2021-09-11"]
[14,"ختوتي نوميديا","2010-11-26","2021-10-16","بنت","الثاني",1,"10--12","لطيفة","ختوتي رشيد","2021-10-16"]
[15,"تاقي اسماعيل","2013-05-28","2022-01-15","ولد","التحضيري",4,"14--16","امال","تاقي محمد","2022-01-15"]
[16,"بوصوفي اسامة","2013-06-05","2021-09-11","ولد","الاول",2,"12--14","ليلى","بوصوفي كريم","2021-09-11"]
[17,"موساتن جيهان","2012-12-25","2021-09-12","بنت","الاول",1,"10--12","ليلى","موساتن عبدالغاني","2021-09-12"]
[18,"موساتن وجدان","2013-12-17","2021-09-12","بنت","الاول",1,"10--12","ليلى","موساتن عبدالغاني","2021-09-12"]
[19,"موساتن الهام","2009-04-09","2021-09-11","بنت","الثالث",1,"12--14","لطيفة","موساتن عبدالصمد","2021-09-11"]
[20,"موساتن محمد","2010-10-22","2021-09-11","ولد","الثاني",1,"10--12","لطيفة","موساتن عبدالصمد","2021-09-11"]

{"sheet":"pagos","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,10,6]]}
["الرقم","padre","أسماء الأبناء","تاريخ التسجيل"]
[1,"القاضي عبدالعزيز",{"$f":"VLookUps(Tabla2[[#This Row],[padre]],datos[#All],\" - \",TRUE)","v":"محمد - نسرين - عبدالحق"}]
[2,"ختوتي طارق",{"$f":"VLookUps(Tabla2[[#This Row],[padre]],datos[#All],\" - \",TRUE)","v":"سفيان - ادم - انس"}]
[3,null,{"$f":"VLookUps(Tabla2[[#This Row],[padre]],datos[#All],\" - \",TRUE)","v":""}]
[4,null,{"$f":"VLookUps(Tabla2[[#This Row],[padre]],datos[#All],\" - \",TRUE)","v":""}]
[5,null,{"$f":"VLookUps(Tabla2[[#This Row],[padre]],datos[#All],\" - \",TRUE)","v":""}]
[6,null,{"$f":"VLookUps(Tabla2[[#This Row],[padre]],datos[#All],\" - \",TRUE)","v":""}]
[]
[null,"اريد ترحيل اسم الاب من ورقة datos مع تاريخ التسجيل بدون تكرار الى الورقة Pagos كالمثال التالي وجزاكم الله خيرا"]