{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dataset","Clearing PivotTable Cache"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Data of XYZ Company"]
[]
[null,"Employee Name","Region","Sales"]
[null,"Peter","South",1400]
[null,"Samuel","East",1700]
[null,"Harry","West",1700]
[null,"Mike","North",1200]
[null,"Lily","South",2000]
[null,"Sarah","North",2100]
[null,"Ben","East",1900]
[null,"Kyle","West",1800]
[null,"Howard","West",1400]
[null,"Kimberly","East",1600]
[null,"Antony","East",1700]

{"sheet":"Clearing PivotTable Cache","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,13]]}
[]
[null,"Clearing PivotTable Cache Using VBA Code",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee Name","Region","Sales",null,"Row Labels","Sum of Sales",null,null,null,null,"Employee Name","Region","Sales"]
[null,"Peter","South",1400,null,"Ben",1900,null,null,null,null,"Peter","South",1400]
[null,"Samuel","East",1700,null,"Harry",1700,null,null,null,null,"Samuel","East",1700]
[null,"Harry","West",1700,null,"Lily",2000,null,null,null,null,"Harry","West",1700]
[null,"Mike","North",1200,null,"Mike",1200,null,null,null,null,"Mike","North",1200]
[null,"Lily","South",2000,null,"Peter",1400,null,null,null,null,"Lily","South",2000]
[null,"Sarah","North",2100,null,"Samuel",1700,null,null,null,null,"Sarah","North",2100]
[null,"Ben","East",1900,null,"Sarah",2100,null,null,null,null,"Ben","East",1900]
[null,null,null,null,null,"Grand Total",12000,null,null,null,null,"Kyle","West",1800]
[null,null,null,null,null,null,null,null,null,null,null,"Howard","West",1400]
[null,null,null,null,null,null,null,null,null,null,null,"Kimberly","East",1600]
[null,null,null,null,null,null,null,null,null,null,null,"Antony","East",1700]