{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sample Dataset","Linking Existing Table","Using Microsoft Query","Applying VBA Code","Using Conditional Formatting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Sample Dataset","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Name","Age","ID"]
[null,"John",52,"32A"]
[null,"Harry",36,"A15"]
[null,"Karen",47,"56E"]
[null,"Tom",61,"30B"]

{"sheet":"Linking Existing Table","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Linking Existing Table"]
[]
[null,{"$f":"Employee","v":"Name"},"Age","ID"]
[null,"John",52,"32A"]
[null,"Harry",36,"A15"]
[null,"Karen",47,"56E"]
[null,"Tom",61,"30B"]

{"sheet":"Using Microsoft Query","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Microsoft Query"]
[]
[null,"Name","Age","ID"]
[null,"John",52,"32A"]
[null,"Harry",36,"A15"]
[null,"Karen",47,"56E"]
[null,"Tom",61,"30B"]

{"sheet":"Applying VBA Code","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Name","Age","ID"]
[null,"John",52,"32A"]
[null,"Harry",36,"A15"]
[null,"Karen",47,"56E"]
[null,"Tom",61,"30B"]

{"sheet":"Using Conditional Formatting","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Conditional Formatting"]
[]
[null,{"$f":"IF(Table2[[#Headers],[Name]]=\"\",\"\",Table2[[#Headers],[Name]])","v":"Name"},{"$f":"IF(Table2[[#Headers],[Age]]=\"\",\"\",Table2[[#Headers],[Age]])","v":"Age"},{"$f":"IF(Table2[[#Headers],[ID]]=\"\",\"\",Table2[[#Headers],[ID]])","v":"ID"}]
[null,{"$f":"IF(Table2[[#This Row],[Name]]=\"\",\"\",Table2[[#This Row],[Name]])","v":"John"},{"$f":"IF(Table2[[#This Row],[Age]]=\"\",\"\",Table2[[#This Row],[Age]])","v":52},{"$f":"IF(Table2[[#This Row],[ID]]=\"\",\"\",Table2[[#This Row],[ID]])","v":"32A"}]
[null,{"$f":"IF(Table2[[#This Row],[Name]]=\"\",\"\",Table2[[#This Row],[Name]])","v":"Harry"},{"$f":"IF(Table2[[#This Row],[Age]]=\"\",\"\",Table2[[#This Row],[Age]])","v":36},{"$f":"IF(Table2[[#This Row],[ID]]=\"\",\"\",Table2[[#This Row],[ID]])","v":"A15"}]
[null,{"$f":"IF(Table2[[#This Row],[Name]]=\"\",\"\",Table2[[#This Row],[Name]])","v":"Karen"},{"$f":"IF(Table2[[#This Row],[Age]]=\"\",\"\",Table2[[#This Row],[Age]])","v":47},{"$f":"IF(Table2[[#This Row],[ID]]=\"\",\"\",Table2[[#This Row],[ID]])","v":"56E"}]
[null,{"$f":"IF(Table2[[#This Row],[Name]]=\"\",\"\",Table2[[#This Row],[Name]])","v":"Tom"},{"$f":"IF(Table2[[#This Row],[Age]]=\"\",\"\",Table2[[#This Row],[Age]])","v":61},{"$f":"IF(Table2[[#This Row],[ID]]=\"\",\"\",Table2[[#This Row],[ID]])","v":"30B"}]