{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["استدعاء وتغيير","قسم1","قسم2","شعبة2","ورقة7"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,0,4,7]]}
["استدعاء البيانات على أساس رقم الكود"]
["الكود","ت","الاسم","الاسم الثاني","المواليد","النوع","الكود","العائد"]
[100,1,{"$f":"VLOOKUP($A$3,قسم1,3,FALSE)","v":"يوسف"},{"$f":"VLOOKUP($A$3,قسم1,4,FALSE)","v":"يعقوب"},{"$f":"VLOOKUP($A$3,قسم1,5,FALSE)","v":98},{"$f":"VLOOKUP($A$3,قسم1,6,FALSE)","v":"ذكر"},{"$f":"VLOOKUP($A$3,قسم1,7,FALSE)","v":100},{"$f":"VLOOKUP($A$3,قسم1,8,FALSE)","v":"عام"}]
[]
["البيانات الجديدة المطلوب تغييرها في كل الشيتات على أساس رقم الكود"]
["الكود","ت","الاسم","الاسم الثاني","المواليد","النوع","الكود","العائد","تاريخ التغيير"]
[100,1,"يوسف","يعقوب",98,"ذكر",100,"عام","2020-03-18"]
[]
[]
[null,null,null,null,"يوجد لدينا ارقام اكواد تعود للعاملين لدينا"]
[null,null,null,null,"فاذا اردنا تغيير أسماء العاملين في كل الشيتات"]
[null,null,null,null,"نذهب الى شيت شيت فنقوم بتغيير البيانات"]
[null,null,null,null,"المطلوب : هو تغييرها مرة واحدة في كل الشيتات ان وجدت"]

{"sheet":"قسم1","index":1,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["الرقم","ت","الاسم","الاسم الثاني","المواليد","النوع","الرقم الثاني","العائد"]
[100,1,"يوسف","يعقوب",98,"ذكر",100,"عام","2020-03-18"]

{"sheet":"قسم2","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["الرقم","ت","الاسم","الاسم الثاني","المواليد","النوع","الرقم الثاني","العائد"]
[100,2,"ابراهيم","يوسف",99,"ذكر",101,"عام","2020-03-23"]

{"sheet":"شعبة2","index":3,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["الرقم","ت","الاسم","الاسم الثاني","المواليد","النوع","الرقم الثاني","العائد"]
[100,1,"يوسف","يعقوب",98,"ذكر",100,"عام","2020-03-18"]

{"sheet":"ورقة7","index":4,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["الرقم","ت","الاسم","الاسم الثاني","المواليد","النوع","الرقم الثاني","العائد"]
[100,1,"يوسف","يعقوب",98,"ذكر",100,"عام","2020-03-18"]