{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1","Sheet1"],"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":"1","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["الكود","السعر","الكميه","الاجمالى","التاريخ"]
[null,null,null,{"$f":"B2*C2","v":0}]
[2,101,20,{"$f":"B3*C3","v":2020},"2012-02-01"]
[3,150,30,4500,"2012-03-01"]
[4,160,40,6400,"2012-04-01"]
[2,170,60,10200,"2012-01-01"]
[3,180,50,9000,"2012-02-01"]
[3,190,80,15200,"2012-01-01"]
[4,200,90,18000,"2012-10-01"]
[null,null,null,0]
[null,null,null,0]
[2,500,200,100000,"2012-01-01"]
[null,null,null,{"$f":"SUBTOTAL(9,D2:D12)","v":165320}]

{"sheet":"Sheet1","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[9,6,9,11],[10,6,10,11],[28,6,28,11],[29,6,29,11],[30,6,30,11],[21,6,21,11],[23,6,23,11],[24,6,24,11],[25,6,25,11],[22,6,22,11],[14,5,14,11],[15,5,15,11],[16,5,16,11],[17,5,18,11],[12,6,12,11]]}
[1,"الكود","السعر","الكميه","الاجمالى","التاريخ"]
[null,1,100,10,{"$f":"C2*D2","v":1000},"2012-01-01"]
[null,2,101,20,{"$f":"C3*D3","v":2020},"2012-02-01"]
[null,3,150,30,4500,"2012-03-01"]
[null,4,160,40,6400,"2012-04-01"]
[null,2,170,60,10200,"2012-01-01"]
[null,3,180,50,9000,"2012-02-01"]
[null,3,190,80,15200,"2012-01-01"]
[null,4,200,90,18000,"2012-10-01"]
[null,1,300,150,45000,"2012-12-01","عند الضغط على زر حذف البياتات المفلتره مع"]
[null,1,400,160,64000,"2012-01-01","النقل الى شيت جديد باسم 1 (بناء على الاسم الموجود"]
[null,2,500,200,100000,"2012-01-01"]
[null,"TOTAL",null,null,{"$f":"SUBTOTAL(9,E2:E12)","v":275320},null,"فى الخليه A1"]
[]
["TOTAL",1,null,null,null,"انا اريد حذف البيانات المعمول عليها فلتر فقط دون حذف المعادلات"]
["TOTAL",2,null,null,null,"المعمول عليها فلتر ايضا"]
["TOTAL",3]
[null,null,null,null,null,"وبذلك يكون الناتج كالاتى"]
[]
[]
[null,"الكود","السعر","الكميه","الاجمالى","التاريخ"]
[null,null,null,null,{"$f":"C22*D22","v":0},null,"لا حظ هنا انه تم حذف الرقم 1  من  جميع الصفوف"]
[null,2,101,20,2020,"2012-02-01"," وما يقابله فى الصفوف "]
[null,3,150,30,4500,"2012-03-01"," من بيانات وتم الابقاء على جميع المعادلات الموجوده "]
[null,4,160,40,6400,"2012-04-01","الخاصه بالرقم 1 الذى تم حذفه"]
[null,2,170,60,10200,"2012-01-01"]
[null,3,180,50,9000,"2012-02-01"]
[null,3,190,80,15200,"2012-01-01"]
[null,4,200,90,18000,"2012-10-01"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"TOTAL",null,null,{"$f":"SUBTOTAL(9,E22:E31)","v":65320}]