{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["قاعدة","بيانات"],"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":"قاعدة","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"الكود","الاسم","بيان1","بيان2"]
[null,101,"عميل1",200,300]
[null,102,"عميل2",300,100]
[null,103,"عميل3",500,250]
[null,104,"عميل4",400,150]
[]
[null,201,"مورد1",150,50]
[null,202,"مور2",200,100]
[null,203,"مورد3",350,200]
[null,204,"مورد4",50,50]

{"sheet":"بيانات","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,10,4,14],[16,8,16,12]]}
[]
["الكود","الاسم","بيان1","بيان2","الإجمالي",null,null,null,null,null,"المطلوب لو ضيفت عميل5 بعد عميل4 وضغطت على زر جمع تنزل جمع القيم  في صف اجمالي العملاء وهاكذا لو ضيفت عميل6 وعميل 7 وكذلك المورد انا عامل تحويل المعادلة الى قيم"]
[101,"عميل1",200,300,500]
[102,"عميل2",300,100,400]
[103,"عميل3",500,250,750]
[104,"عميل4",4,4,4]
[105,"عميل5",16,6,6]
[null,"اجمالي العملاء",1020,660,1660]
[201,"مورد1",150,50,200]
[202,"مور2",200,100,300]
[203,"مورد3",350,200,550]
[null,"مورد4",5,5,5]
[null,"اجمالي الموردين",705,355,1055]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,"الاجمالي العام",{"$f":"C8+C13","v":1725},{"$f":"D8+D13","v":1015},2715,null,null,null,"المطلوب جمع اجمالي العملاء+ اجمالي الموردين"]