{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":1,"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":"ورقة1","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["ت","ر قم الفاتورة","نوع الفاتورة","اسم العميل","المــــــادة","الكمية","وحدة القياس","سعر الوحدة","الخـــــــصم","الإجمــــالي","التاريخ","المخزن"]
[1,1,"فاتورة شراء","مهند","طحين",100,"كيس",20,0,{"$f":"H5*F5","v":2000},"2018-04-05","مخزن1"]
[2,2,"فاتورة شراء","محمد","عدس",200,"كيس",10,0,{"$f":"H6*F6","v":2000},"2018-04-06","مخزن2"]
[3,3,"فاتورة بيع","احمد","طحين",20,"كيس",5,0,100,"2018-04-07","مخزن1"]
[4,4,"فاتورة بيع","سامح","عدس",50,"كيس",7,0,350,"2018-04-08","مخزن2"]
[5,5,"فاتورة شراء","مهند","صابون",100,"كارتون",30,0,3000,"2018-04-08","مخزن3"]
[6,6,null,null,null,null,null,null,null,0,null,"مخزن4"]
[7,7,null,null,null,null,null,null,null,0,null,"مخزن5"]
[8,8,null,null,null,null,null,null,null,0,null,"مخزن6"]
[9,9,null,null,null,null,null,null,null,0,null,"مخزن7"]
[10,10,null,null,null,null,null,null,null,0,null,"مخزن8"]
[11,11,null,null,null,null,null,null,null,0,null,"مخزن9"]
[12,12,null,null,null,null,null,null,null,0,null,"مخزن10"]
[13,13,null,null,null,null,null,null,null,0,null,"مخزن11"]
[14,14,null,null,null,null,null,null,null,0,null,"مخزن12"]
[15,15,null,null,null,null,null,null,null,0,null,"مخزن13"]
[16,16,null,null,null,null,null,null,null,0,null,"مخزن14"]
[17,17,null,null,null,null,null,null,null,0,null,"مخزن15"]
[18,18,null,null,null,null,null,null,null,0,null,"مخزن16"]
[19,19,null,null,null,null,null,null,null,0,null,"مخزن17"]
[20,20,null,null,null,null,null,null,null,0,null,"مخزن18"]
[21,21,null,null,null,null,null,null,null,0,null,"مخزن19"]
[22,22,null,null,null,null,null,null,null,0,null,"مخزن20"]

{"sheet":"ورقة2","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"المخزن","اسم العميل"]
[null,"ادخل اسم المخزن","مخزن3",null,"ادخل اسم العميل","مهند",null,null,null,null,{"$f":"TRIM(C2)","v":"مخزن3"},{"$f":"TRIM(F2)","v":"مهند"}]
[]
["ت","ر قم الفاتورة","نوع الفاتورة","اسم العميل","المــــــادة","الكمية","وحدة القياس","سعر الوحدة","الخـــــــصم","الإجمــــالي","التاريخ","المخزن"]
[5,5,"فاتورة شراء","مهند","صابون",100,"كارتون",30,0,3000,"2018-04-08","مخزن3"]

{"sheet":"ورقة3","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"السلام عليكم و رحمة الله وبركاته"]
[]
[null,null,null,null,null,null,"بعد الشكر و التقدير لكلا من اخوني الأفاضل زيزو و ali"]
[]
[null,"اسم العميل","المخزن",null,null,null,"على الحلول الصحيحة و الرائعة التي قدموها"]
[null,"مهند","مخزن1"]
[null,"محمد","مخزن2",null,null,null,"================================"]
[null,"احمد","مخزن3"]
[null,"سامح","مخزن4",null,null,null,"هذا حل ثالث "]
[null,null,"مخزن5"]
[null,null,"مخزن6",null,null,null,"باستخدام التصفية المتقدمة بالكود"]
[null,null,"مخزن7"]
[null,null,"مخزن8",null,null,null,"اولا : الخانات الحمراء مهمة جدا لعمل الكود"]
[null,null,"مخزن9"]
[null,null,"مخزن10",null,null,null,"ثانيا : لن يقف في طريقك اي معلومة ناقصة"]
[null,null,"مخزن11"]
[null,null,"مخزن12",null,null,null,"اذا ادخلت اسم العميل فقط = تظهر لك بيانات هذا العميل في جميع المخازن"]
[null,null,"مخزن13"]
[null,null,"مخزن14",null,null,null,"اذا ادخلت اسم المخزن و تركت خانة اسم العميل فارغة = تظهر لك كل بيانات هذا المخزن لكل العملاء"]
[null,null,"مخزن15"]
[null,null,"مخزن16",null,null,null,"اذا تركت كلتا الخانتين فارغة = تظهر لك كل البيانات الموجودة في ورقة 1"]
[null,null,"مخزن17"]
[null,null,"مخزن18"]
[null,null,"مخزن19"]
[null,null,"مخزن20"]