{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data1"],"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":"Data1","index":0,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,6,0,7],[22,1,27,6]]}
[null,null,null,null,"الجدول 1",null,"س1",null,null,"البحث",null,null,null,"الجدول 2","المطلوب تحويل ارقام اللجان الى اسماء ملاحظين"]
["عدد الفترات","أسماء \nالمراقبين","عدد\n الفترات","الفترة1","الفترة2","الفترة3","الفترة4","الفترة5","الفترة6","الفترة7","الفترة8","الفترة9",null,"أسماء \nالمراقبين","عدد\n الفترات","الفترة1","الفترة2","الفترة3","الفترة4","الفترة5","الفترة6","الفترة7","الفترة8","الفترة9"]
[8," احمد ",1,3,null,null,null,null,null,null,null,null,null," احمد ",1,"اشرف "]
[8,"اسامة ",2,null,null,null,null,null,null,null,null,null,null,"اسامة ",2]
[8,"اشرف ",3,null,null,null,null,null,null,null,null,null,null,"اشرف ",3]
[8,"الهامي ",4,null,null,null,null,null,null,null,null,null,null,"الهامي ",4]
[8,"ايمن ",5,null,null,null,null,null,null,null,null,null,null,"ايمن ",5]
[8,"بدير ",6,null,null,null,null,null,null,null,null,null,null,"بدير ",6]
[8,"بيومي",7,null,null,null,null,null,null,null,null,null,null,"بيومي",7]
[8,"جمال ",8,null,null,null,null,null,null,null,null,null,null,"جمال ",8]
[]
[null,null,null,null,null,null,null,"الجدول 3"]
["عدد الفترات","أسماء \nالمراقبين","عدد\n الفترات","الفترة1","الفترة2","الفترة3","الفترة4","الفترة5","الفترة6","الفترة7","الفترة8","الفترة9"]
[null," احمد ",1," 1"," 3",null," 7"," 8"," 6"," 4"]
[null,"اسامة ",2," 6"," 5",null,null,null,null,null," 1"]
[null,"اشرف ",3," 4",null,null,null,null," 1",null,null," 7"]
[null,"الهامي ",4," 8",null," 1",null," 6",null," 5"]
[null,"ايمن ",5,null," 7",null,null," 1",null,null," 4"]
[null,"بدير ",6," 5",null," 4"]
[null,"بيومي",7,null,null,null," 5",null,null," 8",null," 1"]
[null,"جمال ",8," 7"," 1",null,null,null," 4"]
[]
[null,"عند نقل جدول1 الذي به هذه الارقام \nالى جدول 2 لا يتم تحويلها الى\n  اسماء في الجدول 3  ماالسبب ؟؟؟  معلومه هذة الارقام تم نسخها من معادلات من جدول اخر... وعند كتابة ارقام في الجدول 2 يدوي ينفذ الامر .... ولا ادري ما السبب؟؟؟؟؟؟؟؟"]