{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"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":"ورقة1","index":0,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,10,10,16],[26,9,26,11]]}
["عمود1","عمود2","عمود3","عمود4","عمود5","عمود6","عمود7","عمود8","عمود9"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B2))","v":1},"احمد","مهدس","معمارى"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B3))","v":2},"محمد","طبيب","أطفال",null,null,null,null,null,null,"مسح بيانات الصف المحدد"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B4))","v":3},"محمود","مهدس","مدنى"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B5))","v":4},"صابر","طبيب","جراحة"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B6))","v":5},"سيد","مدرس","علوم"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B7))","v":""},null,null,null,null,null,null,null,null,null,"مطاوب كود لمسح المدى المحدد دون حذف الصف ثم ترحيل البيانات لاعلى بحيث لا توجد صفوف فارغة بين البيانات وإعادة ترتيب التسلسل 1,2,3"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B8))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B9))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B10))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B11))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B12))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B13))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B14))","v":""},null,null,null,null,null,null,null,null,null,"ترحيل البيانات لاعلى"]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B15))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B16))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B17))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B18))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B19))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B20))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B21))","v":""}]
[{"$f":"IF(الجدول4[[#This Row],[عمود2]]=\"\",\"\",SUBTOTAL(3,$B$2:B22))","v":""}]
[]
[]
[]
["عمود1","عمود2","عمود3","عمود4","عمود5","عمود6","عمود7","عمود8","عمود9"]
[1,"احمد","مهدس","معمارى",null,null,null,null,null,"ليصبح الشكل النهائي هكذا"]
[2,"محمد","طبيب","أطفال"]
[3,"محمود","مهدس","مدنى"]
[4,"صابر","طبيب","جراحة"]
[5,"سيد","مدرس","علوم"]