{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["فواتير","البيانات","عملاء","الاصناف"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,13,4,13],[2,6,2,9],[3,6,3,9],[9,10,9,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"رقم الفاتورة"]
[null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,"كود العميل : ",2,null,null,null,null,null,null,null,null,null,null,null,"المطلوب "]
[null,null,null,null,null,null,"اسم العميل :","محمود",null,null,null,null,null,null,null,null,null,null,1,"كود تعديل الفاتورة وترحيلها "]
[null,null,null,null,null,null,"التـــــاريخ :","2020-01-10",null,null,null,null,null,null,null,null,null,null,2,"كود لحذف الفاتورة"]
[null,null,null,null,null,null,"الـتــعـامـل : ","اجل",null,null,"تاريخ الاستحقاق : ",null,null,"2020-03-01"]
[]
[]
["التاريخ ","رقم الفاتورة","كود \nالعميل","اسم العميل","التعامل ","تاريخ الاستحقاق","كود\n الصنف","الصنف ","السعر","العدد","نسبة \nالخصم","قيمة \nالخصم","الاجمالي","ملاحظـــــــــــــــــــات"]
[{"$f":"IF(G14=\"\",\"\",$H$9)","v":""},{"$f":"IF(G14=\"\",\"\",$K$4)","v":""},{"$f":"IF(G14=\"\",\"\",$H$7)","v":""},{"$f":"IF(G14=\"\",\"\",$H$8)","v":""},{"$f":"IF(G14=\"\",\"\",$H$10)","v":""},{"$f":"IF(G14=\"\",\"\",$N$10)","v":""}]
[{"$f":"IF(G15=\"\",\"\",$H$9)","v":""},{"$f":"IF(G15=\"\",\"\",$K$4)","v":""},{"$f":"IF(G15=\"\",\"\",$H$7)","v":""},{"$f":"IF(G15=\"\",\"\",$H$8)","v":""},{"$f":"IF(G15=\"\",\"\",$H$10)","v":""},{"$f":"IF(G15=\"\",\"\",$N$10)","v":""}]
["","","","","",""]
["","","","","",""]
["","","","","","",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(البيانات!$D:$D,MATCH($K$4,البيانات!$C:$C,0)),\"\")","v":2}]
["","","","","","",null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(البيانات!$D:$D,MATCH($K$4,البيانات!$C:$C,0)),\"\")","v":2}]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]
["","","","","",""]

{"sheet":"البيانات","index":1,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"التاريخ ","رقم الفاتورة","كود \nالعميل","اسم العميل","التعامل ","تاريخ الاستحقاق","كود\n الصنف","الصنف ","السعر","العدد","نسبة \nالخصم","قيمة \nالخصم","الاجمالي","ملاحظـــــــــــــــــــات"]
[null,"2020-01-01",1,1,"محمد","نقدي","2020-05-01",1,"شاشة",1000,1,0,0,1000]
[null,"2020-01-01",1,1,"محمد","نقدي","2020-05-01",2,"لاب توب",3000,1,0,0,3000]
[null,"2020-01-10",2,2,"محمود","اجل","2020-03-01",3,"كيسة",1500,1,0,0,1000]
[null,"2020-01-10",2,2,"محمود","اجل","2020-03-01",2,"لاب توب",3000,1,0,0,3000]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]

{"sheet":"عملاء","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["العملاء"]
["كود العميل","اسم العميل "]
[1,"محمد"]
[2,"محمود "]
[3,"سيد"]
[4,"رجب"]

{"sheet":"الاصناف","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["كود الصنف","اسم الصنف"]
[1,"شاشة"]
[2,"لاب توب"]
[3,"كيسة"]