{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","الاستعلام"],"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":"Sheet1","index":0,"n_rows":30,"n_cols":19,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,2,20,8],[2,13,3,20],[6,4,11,9],[0,4,4,9]]}
[null,null,null,null,"لنفرض اني دخلت الى قاعة البيانات لدي و المكونة من الزبائن او العملاء \nو اذا اردت ان استخلص نتيجة لاي زبون كيف \nلي ان افعل ذلك بالضغط عليه من القائمة مباشرة "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"نتيجة الاستعلام بعد الضغط على اسم الزبون و هذه النتيجة قد يتم استخلاصها في مصنف اخر او صفحة أخرى  "]
[]
[null,"القــــائمة ","الرصيد "]
[null,"زبون 1",{"$f":"SUMIF($C$24:$H$30,B6,$H$24:$H$30)","v":3500},null,null,null,null,null,null,null,null,null,null,"اسم الزبون ","زبون 2",null,null,"المجموع ",{"$f":"SUM(R9:R10)","v":750}]
[null,"زبون 2",{"$f":"SUMIF($C$24:$H$30,B7,$H$24:$H$30)","v":750},null,"المطلوب : باستخدام اكواد VBA عند الضغط على أي اسم من القائمة \nيعطينا استعـــلام او استخلاص لكل حركات الزبون مباشرة"]
[null,"زبون 3",350,null,null,null,null,null,null,null,null,null,null,"التاريخ ","السلعة ","الكمية ","السعر ","المبلغ ","ملاحظة "]
[null,"زبون 4",1400,null,null,null,null,null,null,null,null,null,null,"2019-01-01","سلعة 2",2,250,{"$f":"P9*Q9","v":500}]
[null,"زبون 5",1400,null,null,null,null,null,null,null,null,null,null,"2019-01-02","سلعة 2",1,250,{"$f":"P10*Q10","v":250}]
[null,"زبون 6",1400]
[null,"زبون 7",0]
[null,"زبون 8",0]
[null,"زبون 9",0]
[null,"زبون 10",0]
[]
[]
[]
[]
[]
[null,null,"جدول عام يومي خاص بحركات العملاء اوالزبائن قد يكون في صفحة أخرى او مصنف آخر"]
[]
[null,null,"الزبون ","التاريخ ","السلعة ","الكمية ","السعر ","المبلغ ","ملاحظة "]
[null,null,"زبون 2","2019-01-01","سلعة 2",2,250,{"$f":"F24*G24","v":500}]
[null,null,"زبون 2","2019-01-02","سلعة 2",1,250,{"$f":"F25*G25","v":250}]
[null,null,"زبون 1","2019-01-03","سلعة 1",5,700,3500]
[null,null,"زبون 5","2019-01-04","سلعة 3",4,350,1400]
[null,null,"زبون 6","2019-01-05","سلعة 1",2,700,1400]
[null,null,"زبون 4","2019-01-05","سلعة 1",2,700,1400]
[null,null,"زبون 3","2019-01-05","سلعة 3",1,350,{"$f":"F30*G30","v":350}]

{"sheet":"الاستعلام","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["اسم الزبون ","زبون 2",null,null,"المجموع ",{"$f":"SUM(E7:E8)","v":750}]
[null,null,null,null,null,null,null,null,null,"اختر من القائمة المنسدلة"]
["التاريخ ","السلعة ","الكمية ","السعر ","المبلغ ","ملاحظة "]
["2019-01-01","سلعة 2",2,250,500]
["2019-01-02","سلعة 2",1,250,250]