{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Mali","Fawater","PrintFatora","Fawatersum","Items","Print Barccod"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"Home","index":0,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["فواتير الشراء","فواتير المبيعات","فواتير المردودات","أسم العميل","أجالى فواتير العميل","إجمالي ما دفعه العميل",null,null,null,null,null,null,"اسم المورد","إجمالي فواتير المورد","ما تم دفعه للمورد"]
[1,1,1001,"سمر",null,null,null,null,null,null,null,null,"محمد",0,0]
[2,2,null,"سيف",2266,0,null,null,null,null,null,null,"ايمن",1200,0]
[3,3,null,"زياد",2200,4000,null,null,null,null,null,null,"سعد",1200,1200]
[null,null,null,"محمود"]

{"sheet":"Mali","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["رقم الايصال","نوع الايصال","رقم الفاتورة","صاحب الايصال","مدفوع عن فاتورة بتاريخ","قيمه المبلغ المدفوع","تاريخ الايصال"]
[1,"سند قبض",1002,"زياد","2020-05-29",100,"2020-05-01"]
[2,"سند قبض",1002,"زياد","2020-05-30",100,"2020-05-02"]
[3,"سند قبض",1002,"زياد","2020-05-31",100,"2020-05-03"]
[4,"سند قبض",1002,"زياد","2020-06-01",100,"2020-05-04"]
[5,"سند قبض",1002,"زياد","2020-06-02",100,"2020-05-05"]
[6,"سند قبض",1001,"زياد","2020-06-03",100,"2020-05-06"]
[7,"سند قبض",1001,"زياد","2020-06-04",100,"2020-05-07"]
[8,"سند قبض",1001,"زياد","2020-06-05",100,"2020-05-08"]
[9,"سند قبض",1001,"زياد","22/05/2020",100,"2020-01-01"]
[10,"سند قبض",1001,"زياد","22/05/2020",100,"2020-10-10"]

{"sheet":"Fawater","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","كود","اسم الماده","الكميه","السعر","الإجمالى","تاريخ الفاتورة","نوع الفاتورة","إسم العميل"]
[1001,2,"قميص",4,200,800,"27/05/2020","فاتورة مبيعات"]
[1001,2,"قميص",4,200,800,"27/05/2020","فاتورة مبيعات"]
[1001,2,"قميص",4,200,800,"27/05/2020","فاتورة مبيعات"]
[2,4,"حذاء",3,400,1200,"28/05/2020","فاتورة مشتريات"]
[5,4,"حذاء",3,400,1200,"30/05/2020","فاتورة مشتريات"]
[3,103,"قميص",2,300,600,"2020-03-06","فاتورة مبيعات","سيف"]
[3,104,"تيشيرت",2,333,666,"2020-03-06","فاتورة مبيعات","سيف"]
[3,105,"حذاء",2,500,1000,"2020-03-06","فاتورة مبيعات","سيف"]
[3,104,"تيشيرت",2,333,666,"2020-03-06","فاتورة مشتريات","محمد"]
[3,104,"تيشيرت",2,333,666,"2020-03-07","فاتورة مشتريات","سيد"]
[3,104,"تيشيرت",2,333,666,"2020-03-08","فاتورة مشتريات","محسن"]
[3,104,"تيشيرت",2,333,666,"2020-03-09","فاتورة مشتريات","احمد"]
[3,104,"تيشيرت",2,333,666,"2020-03-10","فاتورة مشتريات","سيف"]
[3,104,"تيشيرت",2,333,666,"2020-03-11","فاتورة مبيعات","سمر"]
[3,104,"تيشيرت",2,333,666,"2020-03-12","فاتورة مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-06","مردودات مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-07","مردودات مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-08","مردودات مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-09","مردودات مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-10","مردودات مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-11","مردودات مبيعات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-12","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-13","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-14","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-15","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-16","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-17","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-18","مردودات مشتريات","زياد"]
[1001,103,"قميص",3,300,900,"2020-05-19","مردودات مشتريات","زياد"]

{"sheet":"PrintFatora","index":3,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,5,6,6],[4,5,4,6],[5,5,5,6]]}
[]
[]
[null,null,"فاتورة مبيعات","نوع الفاتورة :"]
[]
[null,null,"سيف","إسم العميل :"]
[null,null,3,"رقم الفاتورة :"]
[null,null,"2020-06-03","تاريخ الفاتورة :"]
[]
[]
[]
[]
[null,null,"أسم المنتج","الكمية","السعر","الاجمالى",null,null,null,"م"]
[]
[3,103,"قميص",2,300,600,"2020-06-03","فاتورة مبيعات"]
[3,104,"تيشيرت",2,333,666,"2020-06-03","فاتورة مبيعات"]
[3,105,"حذاء",2,500,1000,"2020-06-03","فاتورة مبيعات"]
[3,104,"تيشيرت",2,333,666,"2020-11-03","فاتورة مبيعات"]
[3,104,"تيشيرت",2,333,666,"2020-12-03","فاتورة مبيعات"]
[]
[null,null,"عدد القطع المباعه",10]
[null,null,"إجمالى الفاتورة",3598]
[null,null,"قيمه الخصم",1000]
[null,null,"أجمالى سعر الفاتورة بعد الخصم",2598]
[null,null,"قيمه المبلغ المدفوع","-266.00 $"]

{"sheet":"Fawatersum","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","نوع الفاتورة","تاريخ الفاتورة","اسم العميل / المورد","الإجمالى","الخصم","المدفوع","رقم فاتورة المورد"]
[1001,"فاتورة مشتريات","27/05/2020","محمد",0,0,0,23456]
[1001,"فاتورة مبيعات","27/05/2020","زياد",1441.5,0,0]
[1002,"فاتورة مبيعات","2020-05-22","زياد",9999,9999,5555]
[2,"فاتورة مشتريات","28/05/2020","سعد",1200,10,1200]
[3,"فاتورة مشتريات","30/05/2020","ايمن",1200,0,0,1000000001]
[3,"فاتورة مبيعات","2020-03-06","سيف",2266,0,0]
[4,"فاتورة مردودات","2020-03-07","سيف",2266,0,0]
[3,"فاتورة مبيعات","2020-03-06","سيف",2266,0,0]
[4,"فاتورة مبيعات","2020-03-07","سيف",2266,0,0]
[5,"فاتورة مبيعات","2020-03-08","سيف",2266,0,0]
[6,"فاتورة مبيعات","2020-03-09","سيف",2266,0,0]
[7,"فاتورة مبيعات","2020-03-10","سيف",2266,0,0]
[8,"فاتورة مبيعات","2020-03-11","سيف",2266000,0,0]
[9,"فاتورة مبيعات","2020-03-12","سيف",2266,0,0]
[10,"فاتورة مبيعات","2020-03-13","سيف",2266,0,0]
[1001,"مردودات مبيعات","2020-05-06","زياد",1800,0,0]
[1002,"مردودات مبيعات","2020-05-07","زياد",1800,0,0]
[1003,"مردودات مبيعات","2020-05-08","زياد",1800,0,0]
[1004,"مردودات مبيعات","2020-05-09","زياد",1800,0,0]
[1005,"مردودات مبيعات","2020-05-10","زياد",1800,0,0]
[1006,"مردودات مشتريات","2020-05-11","زياد",1800,0,0]
[1007,"مردودات مشتريات","2020-05-12","زياد",1800,0,0]
[1008,"مردودات مشتريات","2020-05-13","زياد",1800,0,0]
[1009,"مردودات مشتريات","2020-05-14","زياد",1800,0,0]
[1010,"مردودات مشتريات","2020-05-15","زياد",1800,0,0]
[1011,"مردودات مشتريات","2020-05-16","زياد",1800,0,0]
[1012,"مردودات مشتريات","2020-05-17","زياد",1800,0,0]
[1013,"مردودات مشتريات","2020-05-18","زياد",1800,0,0]

{"sheet":"Items","index":5,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["كود الماده","اسم الماده ","الكميه","سعر الشراء","سعر البيع","الكمية في المخزن","تاريخ اضافه الصنف","باركوود","رقم الموديل"]
[102,"بنطلون",8,100,null,8,"2020-04-01",1010001,89]
[103,"قميص",12,200,300,12,"2020-04-02",1010002,89]
[104,"تيشيرت",20,300,333,20,"2020-04-03",1010003,89]
[105,"حذاء",78,400,500,68,"2020-04-04",1010004,89]
[106,"شراب",null,null,null,null,"2020-08-06",1010005,1235524]

{"sheet":"Print Barccod","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[1010004,null,"Excel Barcood Design\nModel No : 89\nPrice         : 500 جنيه\nItem Name    : حذاء"]