{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","BLANK","Formula","VBA","Avoid Blank cells","UNDO"],"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":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Name","Age","Joining date","Salary"]
[null,"John",29,"2021-03-01",2000]
[null,"David",30,null,2500]
[null,"James",24,"2019-01-01",3000]
[null,"Robert",null,"2020-06-01",3000]
[null,"Maria",42,"2021-05-01"]
[null,"Emma",null,"2019-12-01",4000]
[null,"Mary",25,"2021-12-01"]

{"sheet":"BLANK","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using BLANK Option"]
[]
[null,"Name","Age","Joining date","Salary"]
[null,"John",29,"2021-03-01",2000]
[null,"David",30,null,2500]
[null,"James",24,"2019-01-01",3000]
[null,"Robert",null,"2020-06-01",3000]
[null,"Maria",42,"2021-05-01"]
[null,"Emma",null,"2019-12-01",4000]
[null,"Mary",25,"2021-12-01"]

{"sheet":"Formula","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Formula for Blank Cells"]
[]
[null,"Name","Age","Joining date","Salary"]
[null,"John",29,"2021-03-01",2000]
[null,"David",30,null,2500]
[null,"James",24,"2019-01-01",3000]
[null,"Robert",null,"2020-06-01",3000]
[null,"Maria",42,"2021-05-01"]
[null,"Emma",null,"2019-12-01",4000]
[null,"Mary",25,"2021-12-01"]

{"sheet":"VBA","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Codes"]
[]
[null,"Name","Age","Joining date","Salary"]
[null,"John",29,"2021-03-01",2000]
[null,"David",30,null,2500]
[null,"James",24,"2019-01-01",3000]
[null,"Robert",null,"2020-06-01",3000]
[null,"Maria",42,"2021-05-01"]
[null,"Emma",null,"2019-12-01",4000]
[null,"Mary",25,"2021-12-01"]

{"sheet":"Avoid Blank cells","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Name","Age","Joining date","Salary"]
[null,"John",29,"2021-03-01",2000]
[null,"David",30,null,2500]
[null,"James",24,"2019-01-01",3000]
[null,"Robert",null,"2020-06-01",3000]
[null,"Maria",42,"2021-05-01"]
[null,"Emma",null,"2019-12-01",4000]
[null,"Mary",25,"2021-12-01"]

{"sheet":"UNDO","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Clear the Conditional Formatting"]
[]
[null,"Name","Age","Joining date","Salary"]
[null,"John",29,"2021-03-01",2000]
[null,"David",30,null,2500]
[null,"James",24,"2019-01-01",3000]
[null,"Robert",null,"2020-06-01",3000]
[null,"Maria",42,"2021-05-01"]
[null,"Emma",null,"2019-12-01",4000]
[null,"Mary",25,"2021-12-01"]