{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,9,6,9],[12,2,14,4]]}
["sheet2",null,null,null,null,null,null,null,null,"المطلوب كود يقوم بتجهيز عمود تاريخ الحساب بحيث فقط يتم اظهار الصفوف الواقعة بين التاريخين المسجلين فى العمود   G   وباقى الصفوف تختفى"]
[null,null,null,null,null,"اول تاريخ","2005-07-23"]
[]
[null,null,null,null,null,"اخر تاريخ","2010-07-28"]
[]
[]
[]
[]
["تاريخ الحساب"]
[{"$f":"IFERROR(INDIRECT(A1&\"!A2\"),\"\")","v":"2005-07-04"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A3\"),\"\")","v":"2006-07-23"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A4\"),\"\")","v":"2007-07-29"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A5\"),\"\")","v":"2008-08-13"},null,"يتم جلب التواريخ من  Sheet2 "]
[{"$f":"IFERROR(INDIRECT(A1&\"!A6\"),\"\")","v":"2009-07-18"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A7\"),\"\")","v":"2010-07-25"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A10\"),\"\")","v":"2010-07-28"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A11\"),\"\")","v":"2010-07-29"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A12\"),\"\")","v":"2010-07-30"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A13\"),\"\")","v":"2011-04-11"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A14\"),\"\")","v":"2012-04-07"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A15\"),\"\")","v":"2016-09-12T01:00:00"}]
[{"$f":"IFERROR(INDIRECT(A1&\"!A16\"),\"\")","v":"2016-11-05T02:00:00"}]

{"sheet":"sheet2","index":1,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ"]
["2005-07-04"]
["2006-07-23"]
["2007-07-29"]
["2008-08-13"]
["2009-07-18"]
["2010-07-25"]
["2010-07-26"]
["2010-07-27"]
["2010-07-28"]
["2010-07-29"]
["2010-07-30"]
["2011-04-11"]
[41006]
[42625.041666666664]
[42679.083333333336]