{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","For a Range","With Value","Specific value","Formula","For a selection"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,11,2]]}
[]
[]
[null,"Sales Record"]
[]
[null,"Product","Date","Price"]
[null,"MacBook Air","2022-12-09",1199]
[null,"AirPods","2022-12-28",249]
[null,"MacBook Pro","2022-12-10",1299]
[null,"iPad Pro","2022-12-04",799]
[null,"AirPods","2022-12-15",249]
[]
[null,"Count of Filled Cells"]

{"sheet":"For a Range","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,11,2],[2,6,2,8],[11,6,11,7]]}
[]
[]
[null,"Sales Record",null,null,null,null,"Try Yourself"]
[]
[null,"Product","Date","Price",null,null,"Product","Date","Price"]
[null,"MacBook Air","2022-12-09",1199,null,null,"MacBook Air","2022-12-09",1199]
[null,"AirPods","2022-12-28",249,null,null,"AirPods","2022-12-28",249]
[null,"MacBook Pro","2022-12-10",1299,null,null,"MacBook Pro","2022-12-10",1299]
[null,"iPad Pro","2022-12-04",799,null,null,"iPad Pro","2022-12-04",799]
[null,"AirPods","2022-12-15",249,null,null,"AirPods","2022-12-15",249]
[]
[null,"Count of Filled Cells",null,18,null,null,"Count of Filled Cells"]

{"sheet":"With Value","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,11,2],[2,6,2,8],[11,6,11,7]]}
[]
[]
[null,"Sales Record",null,null,null,null,"Try Yourself"]
[]
[null,"Product","Date","Price",null,null,"Product","Date","Price"]
[null,"MacBook Air","2022-12-09",1199,null,null,"MacBook Air","2022-12-09",1199]
[null,"AirPods","2022-12-28",249,null,null,"AirPods","2022-12-28",249]
[null,"MacBook Pro","2022-12-10",1299,null,null,"MacBook Pro","2022-12-10",1299]
[null,"iPad Pro","2022-12-04",799,null,null,"iPad Pro","2022-12-04",799]
[null,"AirPods","2022-12-15",249,null,null,"AirPods","2022-12-15",249]
[]
[null,"Count of Filled Cells",null,10,null,null,"Count of Filled Cells"]

{"sheet":"Specific value","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Sales Record",null,null,null,null,"Try Yourself"]
[]
[null,"Product","Date","Price",null,null,"Product","Date","Price"]
[null,"MacBook Air","2022-12-09",1199,null,null,"MacBook Air","2022-12-09",1199]
[null,"AirPods","2022-12-28",249,null,null,"AirPods","2022-12-28",249]
[null,"MacBook Pro","2022-12-10",1299,null,null,"MacBook Pro","2022-12-10",1299]
[null,"iPad Pro","2022-12-04",799,null,null,"iPad Pro","2022-12-04",799]
[null,"AirPods","2022-12-15",249,null,null,"AirPods","2022-12-15",249]

{"sheet":"Formula","index":4,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,11,2],[2,6,2,8],[11,6,11,7]]}
[]
[]
[null,"Sales Record",null,null,null,null,"Try Yourself"]
[]
[null,"Product","Date","Price",null,null,"Product","Date","Price"]
[null,"MacBook Air","2022-12-09",1199,null,null,"MacBook Air","2022-12-09",1199]
[null,"AirPods","2022-12-28",249,null,null,"AirPods","2022-12-28",249]
[null,"MacBook Pro","2022-12-10",1299,null,null,"MacBook Pro","2022-12-10",1299]
[null,"iPad Pro","2022-12-04",799,null,null,"iPad Pro","2022-12-04",799]
[null,"AirPods","2022-12-15",249,null,null,"AirPods","2022-12-15",249]
[]
[null,"Count of Filled Cells",null,{"$f":"COUNT(D6:D10)","v":5},null,null,"Count of Filled Cells"]

{"sheet":"For a selection","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Sales Record",null,null,null,null,"Try Yourself"]
[]
[null,"Product","Date","Price",null,null,"Product","Date","Price"]
[null,"MacBook Air","2022-12-09",1199,null,null,"MacBook Air","2022-12-09",1199]
[null,"AirPods","2022-12-28",249,null,null,"AirPods","2022-12-28",249]
[null,"MacBook Pro","2022-12-10",1299,null,null,"MacBook Pro","2022-12-10",1299]
[null,"iPad Pro","2022-12-04",799,null,null,"iPad Pro","2022-12-04",799]
[null,"AirPods","2022-12-15",249,null,null,"AirPods","2022-12-15",249]