{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","الفلتر","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Feuil1","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,3,4,12],[5,3,5,12]]}
[]
[]
[]
[]
[null,null,null,"اريد كود او معادلة لاستخراج كل البيانات مفلترة حسب المحافظة مثلا اكتب في صفحة الفلتر اسم المحافظة يجلب لي كل الصفوف المتعلقة بالمحافظة "]
[null,null,null,"وعمود الرقم يكون مرتب من 1 الى غاية انتهاء بيانات الصف يعني 1 2 3 4 5... كما ان الجدول يمكن ان يحتوي على اكثر من 1000 صف به بيانات "]
[]
[]
["الرقم","عنوان البريد الإلكتروني","اللقب ","الاسم","تاريخ الميلاد","الفئة","العنوان الشخصي ","المحافظة","القسم","رقم الهاتف الشخصي","بكالوريوس","التخصص","الحالة المدنية "]
[1,"dsdsdds@gmail.com","احمد","علي","2000-01-01","مهندس","ابابابااباباابااااا","القاهرة","مصر",21212121,"علوم","بيطرة","اعزب"]
[2,"dsdsdds@gmail.com","ياسر","خليل","2000-01-02","عملاق الاكسيل","يشسثضصصض","الاردن","الزرقاء",54545454,"اداب","لغات","اعزب"]
[3,"dsdsdds@gmail.com","عبد الجليل","ابو محمد","2000-01-03","مبتدئ","ليبيليبيبيلؤبؤ","الجزائر","العاصمة",5458798,"علوم","رياضيات","متزوج"]
[4,"dsdsdds@gmail.com","احمد","مصطفى","2000-01-04","مراقب","فثقثقثفقثقثف","القاهرة","مصر",896321,"علوم","اعلاام الي","متزوج"]
[5,"dsdsdds@gmail.com","علي","علي","2000-01-05","مهندس","عغعغعغعغعغع","الاردن","الزرقاء",896322,"علوم","اعلاام الي","متزوج"]
[6,"dsdsdds@gmail.com","كمال","يحي","2000-01-06","مبتدئ","ليبيليبيبيلؤبؤ","الاردن","الزرقاء",896323,"علوم","اعلاام الي","متزوج"]
[7,"dsdsdds@gmail.com","جمال ","فخراني","2000-01-07","مهندس","ابابابااباباابااااا","القاهرة","مصر",896324,"علوم","اعلاام الي","متزوج"]
[8,"dsdsdds@gmail.com","حسن محمد","علي","2000-01-08","مبتدئ","ليبيليبيبيلؤبؤ","الاردن","الزرقاء",896323,"علوم","اعلاام الي","متزوج"]

{"sheet":"الفلتر","index":1,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"المحافظة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"القاهرة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الاردن"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الجزائر"]
[null,null,null,null,null,null,null,"المحافظة"]
[null,null,null,null,null,null,null,"الجزائر"]
[]
[]
["الرقم","عنوان البريد الإلكتروني","اللقب ","الاسم","تاريخ الميلاد","الفئة","العنوان الشخصي ","المحافظة","القسم","رقم الهاتف الشخصي","بكالوريوس","التخصص","الحالة المدنية "]
[3,"dsdsdds@gmail.com","عبد الجليل","ابو محمد","2000-01-03","مبتدئ","ليبيليبيبيلؤبؤ","الجزائر","العاصمة",5458798,"علوم","رياضيات","متزوج"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}