{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sample Dataset","Sorting Pivot Table by Values","VBA Code to Sort by Values"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":2},"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":"Sample Dataset","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Dataset"]
[]
[null,"Products","January Sales","February Sales","March Sales"]
[null,"Blender",1000,1000,1200]
[null,"Cloths Iron",2000,2200,1800]
[null,"Electric Kettle",800,700,1000]
[null,"Electric Trimmer",800,500,900]
[null,"Hair Dryer",3500,3000,2800]
[null,"Sandwich Maker",1000,1200,900]
[null,"Toaster",1200,1500,1800]
[null,"Vacuum Cleaner",3500,3200,2500]

{"sheet":"Sorting Pivot Table by Values","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Sorting Pivot Table by Values"]
[]
["Row Labels","Sum of January Sales","Sum of February Sales","Sum of March Sales"]
["Blender",1000,1000,1200]
["Cloths Iron",2000,2200,1800]
["Electric Kettle",800,700,1000]
["Electric Trimmer",800,500,900]
["Hair Dryer",3500,3000,2800]
["Sandwich Maker",1000,1200,900]
["Toaster",1200,1500,1800]
["Vacuum Cleaner",3500,3200,2500]
["Grand Total",13800,13300,12900]

{"sheet":"VBA Code to Sort by Values","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Using a VBA Code to Sort by Values"]
[]
["Row Labels","Sum of January Sales","Sum of February Sales","Sum of March Sales"]
["Electric Trimmer",800,500,900]
["Electric Kettle",800,700,1000]
["Blender",1000,1000,1200]
["Sandwich Maker",1000,1200,900]
["Toaster",1200,1500,1800]
["Cloths Iron",2000,2200,1800]
["Hair Dryer",3500,3000,2800]
["Vacuum Cleaner",3500,3200,2500]
["Grand Total",13800,13300,12900]