{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Single Column","Multiple Columns (1)","Multiple Columns (2)","Single Row","Multiple Rows","VBA"],"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":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sales Record of Mars Group"]
[]
[null,"Product Name",2016,2017,2018,2019,2020]
[null,"Desktop",150,189,102,287,391]
[null,"Laptop",264,542,665,303,217]
[null,"Smartphone",984,1207,1553,832,776]
[null,"Landphone",128,65,89,198,101]
[null,"Telephone",288,387,456,693,359]
[null,"Refrigerator",572,561,532,476,598]
[null,"Television",489,499,503,772,1212]
[null,"Table Fan",965,1301,1567,1309,1234]
[null,"Microwave Oven",773,1007,1047,1597,2150]

{"sheet":"Single Column","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Conditional Formatting on Multiple Values for Single Column"]
[]
[null,"Product Name",2016,2017,2018,2019,2020]
[null,"Desktop",150,189,102,287,391]
[null,"Laptop",264,542,665,303,217]
[null,"Smartphone",984,1207,1553,832,776]
[null,"Landphone",128,65,89,198,101]
[null,"Telephone",288,387,456,693,359]
[null,"Refrigerator",572,561,532,476,598]
[null,"Television",489,499,503,772,1212]
[null,"Table Fan",965,1301,1567,1309,1234]
[null,"Microwave Oven",773,1007,1047,1597,2150]

{"sheet":"Multiple Columns (1)","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Conditional Formatting on Multiple Values for Multiple Columns"]
[]
[null,"Product Name",2016,2017,2018,2019,2020]
[null,"Desktop",150,189,102,287,391]
[null,"Laptop",264,542,665,303,217]
[null,"Smartphone",984,1207,1553,832,776]
[null,"Landphone",128,65,89,198,101]
[null,"Telephone",288,387,456,693,359]
[null,"Refrigerator",572,561,532,476,598]
[null,"Television",489,499,503,772,1212]
[null,"Table Fan",965,1301,1567,1309,1234]
[null,"Microwave Oven",773,1007,1047,1597,2150]

{"sheet":"Multiple Columns (2)","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Conditional Formatting on Multiple Values for Multiple Columns"]
[]
[null,"Product Name",2016,2017,2018,2019,2020]
[null,"Desktop",150,189,102,287,391]
[null,"Laptop",264,542,665,303,217]
[null,"Smartphone",984,1207,1553,832,776]
[null,"Landphone",128,65,89,198,101]
[null,"Telephone",288,387,456,693,359]
[null,"Refrigerator",572,561,532,476,598]
[null,"Television",489,499,503,772,1212]
[null,"Table Fan",965,1301,1567,1309,1234]
[null,"Microwave Oven",773,1007,1047,1597,2150]

{"sheet":"Single Row","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Conditional Formatting on Multiple Values for Single Row"]
[]
[null,"Product Name",2016,2017,2018,2019,2020]
[null,"Desktop",110,189,102,287,391]
[null,"Laptop",164,542,665,303,217]
[null,"Smartphone",984,1207,1553,832,776]
[null,"Landphone",128,65,89,198,101]
[null,"Telephone",288,387,456,693,359]
[null,"Refrigerator",572,561,532,476,598]
[null,"Television",489,499,503,772,1212]
[null,"Table Fan",965,1301,1567,1309,1234]
[null,"Microwave Oven",773,1007,1047,1597,2150]

{"sheet":"Multiple Rows","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Conditional Formatting on Multiple Values for Multiple Rows"]
[]
[null,"Product Name",2016,2017,2018,2019,2020]
[null,"Desktop",110,189,102,287,391]
[null,"Laptop",164,542,665,303,217]
[null,"Smartphone",984,1207,1553,632,776]
[null,"Landphone",128,65,89,198,101]
[null,"Telephone",288,387,456,693,359]
[null,"Refrigerator",572,561,532,476,598]
[null,"Television",489,499,503,772,212]
[null,"Table Fan",965,1301,1567,709,834]
[null,"Microwave Oven",773,1007,1047,1097,1150]

{"sheet":"VBA","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Conditional Formatting Using VBA"]
[]
[null,"Sales Rep","Sales",null,"Target Sales"]
[null,"John",1495,null,1500]
[null,"Peter",1447]
[null,"Ryan",1500]
[null,"Conway",1568]
[null,"Nicholas",1432]
[null,"Max",1532]
[null,"Smith",1466]