{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Set 1","Data Set 2","Consolidating","Append","Merge","VBA"],"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":"Data Set 1","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Data Set 1"]
[]
[null,"Product \nName","January Sales","February Sales","March \nSales"]
[null,"Hair Dryer",3500,3000,2800]
[null,"Vaccum Cleaner",3500,3200,2500]
[null,"Blender",1000,1000,1200]
[null,"Cloths Iron",2000,2200,1800]

{"sheet":"Data Set 2","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Data Set 2"]
[]
[null,"Product \nName","January Sales","February Sales","March \nSales"]
[null,"Hair Dryer",3200,2800,3500]
[null,"Vaccum Cleaner",3500,2500,2900]
[null,"Blender",800,1200,950]
[null,"Cloths Iron",2500,2300,1900]

{"sheet":"Consolidating","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Consolidating Data from Multiple Worksheets"]
[]
[null,"Product\nName","January \nSales","February \nSales","March \nSales"]
[null,"Hair Dryer",6700,5800,6300]
[null,"Vaccum Cleaner",7000,5700,5400]
[null,"Blender",1800,2200,2150]
[null,"Cloths Iron",4500,4500,3700]

{"sheet":"Append","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Product \nName","January Sales","February Sales","March \nSales"]
["Hair Dryer",3500,3000,2800]
["Vaccum Cleaner",3500,3200,2500]
["Blender",1000,1000,1200]
["Cloths Iron",2000,2200,1800]
["Hair Dryer",3200,2800,3500]
["Vaccum Cleaner",3500,2500,2900]
["Blender",800,1200,950]
["Cloths Iron",2500,2300,1900]

{"sheet":"Merge","index":4,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Product \nName","January Sales","February Sales","March \nSales","January Sales.1","February Sales.1","March \nSales.1"]
["Hair Dryer",3500,3000,2800,3200,2800,3500]
["Vaccum Cleaner",3500,3200,2500,3500,2500,2900]
["Blender",1000,1000,1200,800,1200,950]
["Cloths Iron",2000,2200,1800,2500,2300,1900]

{"sheet":"VBA","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Product \nName","January \nSales","February Sales","March \nSales"]
[null,"Hair Dryer",3500,3000,2800]
[null,"Vaccum Cleaner",3500,3200,2500]
[null,"Blender",1000,1000,1200]
[null,"Cloths Iron",2000,2200,1800]
[null,"Hair Dryer",3200,2800,3500]
[null,"Vaccum Cleaner",3500,2500,2900]
[null,"Blender",800,1200,950]
[null,"Cloths Iron",2500,2300,1900]