{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["البيانات","الطباعة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"البيانات","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,2,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14]]}
[]
[]
[]
["م","الاسم","إجازة عارضة",null,null,null,null,null,null,"اعتيادى",null,"المرضى",null,"الوضع",null,"بدون مرتب"]
[null,"احمد","2024-07-01","2024-07-02","2024-07-03",null,null,null,null,"2024-07-11","2024-07-12"]
[null,"احمد",null,null,null,null,null,null,null,"2024-08-02","2024-08-03"]
[null,"احمد",null,null,null,null,null,null,null,"2024-09-13","2024-09-14"]
[null,"احمد"]
[null,"على"]
[null,"هانى"]

{"sheet":"الطباعة","index":1,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,12,11,12],[5,0,5,2],[7,0,7,4],[9,0,9,2],[9,3,9,5],[9,6,9,8],[9,9,9,11],[2,0,2,8],[6,0,6,2]]}
[null,null,null,null,null,"احمد"]
[null,null,null,null,null,null,null,null,null,null,null,null,"السلام عليكم ورحمة الله وبركاته بعد اذن أستاذة منتدى اوفيسنا الكرام قمت بنسخ الكود الموجود في الشيت وضبطت كل شى ولكن الضغط على الزر لجلب البيانات المفروض يقوم بمسح نطاق من A5:G5 ولكن يقوم بمسح حتى الاسطر اللى بعد ذلك حتى السطر اللى مكتوب ملاحظات يقوم بمسح هذه الاسطر ممكن معالجة هذا الخطا المطلوب بمسح A5:G5 '"]
["عدد أيام العارضة"]
["اليوم الأول","اليوم الثانى","اليوم الثالث","اليوم الرابع","اليوم الخامس","اليوم السادس","اليوم السابع","عدد يام الغياب","التوقيع بالعلم"]
[]
["ملاحظات"]
["الاجازات المسموح بها للموظف"]
["الإجراءات المتخذة عند التعدى على الاجازة الاعارضة"]
[]
["اعتيادى",null,null,"المرضى",null,null,"الوضع",null,null,"بدون مرتب"]
["من","الى","عدد الأيام","من","الى","عدد الأيام","من","الى","عدد الأيام","من","الى","عدد الأيام"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(A22=\"\",\"\",B22-A22+1)","v":""},null,null,{"$f":"IF(E22=\"\",\"\",E22-D22+1)","v":""},null,null,{"$f":"IF(G22=\"\",\"\",H22-G22+1)","v":""},null,null,{"$f":"IF(J22=\"\",\"\",K22-J22+1)","v":""}]
[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,""]