{"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":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["الكود","الرقم","التاريخ1","التاريخ2","التاريخ3"]
[100,1435500,"2024-02-26","2024-02-28","2024-03-01"]
[101,1368545,"2024-02-25","2024-02-28","2024-03-01"]
[102,1368555,"2024-02-01","2024-02-28","2024-03-01"]
[103,1368550,"2024-02-26","2024-02-28","2024-03-01"]
[104,1368634,"2024-02-26","2024-02-28","2024-03-01"]
[105,1368586,"2024-02-26","2024-02-28","2024-03-01"]
[106,1368639,"2024-02-26","2024-02-28","2024-03-01"]

{"sheet":"الجدول","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,8,6,11],[3,8,3,11],[8,8,10,11]]}
[]
[]
["الكود","ت","الرقم","التاريخ1"]
[100,1,{"$f":"VLOOKUP(A4,البيانات!$A$2:$E$8,2,0)","v":1435500},{"$f":"VLOOKUP(A4,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-26"},null,null,null,null,"معادلة لجلب البيانات على أساس (شرطين) رأس الجدول والكود"]
[101,2,{"$f":"VLOOKUP(A5,البيانات!$A$2:$E$8,2,0)","v":1368545},{"$f":"VLOOKUP(A5,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-25"},null,null,null,null,"اذا كتبنا في D3 التاريخ 1 يأتي التاريخ الموجود في شيت البيانات"]
[102,3,{"$f":"VLOOKUP(A6,البيانات!$A$2:$E$8,2,0)","v":1368555},{"$f":"VLOOKUP(A6,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-01"}]
[103,4,{"$f":"VLOOKUP(A7,البيانات!$A$2:$E$8,2,0)","v":1368550},{"$f":"VLOOKUP(A7,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-26"}]
[104,5,{"$f":"VLOOKUP(A8,البيانات!$A$2:$E$8,2,0)","v":1368634},{"$f":"VLOOKUP(A8,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-26"}]
[105,6,{"$f":"VLOOKUP(A9,البيانات!$A$2:$E$8,2,0)","v":1368586},{"$f":"VLOOKUP(A9,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-26"},null,null,null,null,"واذا كتبنا كتبنا في D3 التاريخ 2 يأتي التاريخ2 الموجود في شيت البيانات"]
[106,7,{"$f":"VLOOKUP(A10,البيانات!$A$2:$E$8,2,0)","v":1368639},{"$f":"VLOOKUP(A10,البيانات!$A$2:$E$8,MATCH($D$3,البيانات!$A$1:$E$1,0),0)","v":"2024-02-26"}]