{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Achat","Detail","By_date"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Achat","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد"]
[635,"بدران",100,"2019-01-01",100]
[684,"رشيد",50,"2019-01-01",50]
[360,"حماد",25,"2019-01-01",20]
[635,"بدران",10,"2019-01-02",10]
[684,"رشيد",15,"2019-01-02",10]
[635,"بدران",70,"2019-01-03",50]
[360,"حماد",10,"2019-01-03",10]

{"sheet":"Detail","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد","المتبقي بذمة الزبون"]
[635,"بدران",100,"2019-01-01",100,20]
[635,"بدران",10,"2019-01-02",10]
[635,"بدران",70,"2019-01-03",50]
[null,null,{"$f":"SUM(C2:C4)","v":180},null,{"$f":"SUM(E2:E4)","v":160}]
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد",null,"تم إضافة عمود التسديد وتم التعديل على الكود"]
[684,"رشيد",50,"2019-01-01",50,null,"اجراء عملية الجمع في خانة سي والطرح في خانة اف"]
[684,"رشيد",15,"2019-01-02",10]
[]
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد"]
[360,"حماد",25,"2019-01-01",20]
[360,"حماد",10,"2019-01-03",10]

{"sheet":"By_date","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["مجموع مبلغ الشراء حسب التاريخ","التاريخ"]
[175,"2019-01-01"]
[25,"2019-01-02"]
[80,"2019-01-03"]