{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Sheet1","Delete Rows","Exercise"],"not_rendered":{"charts":0,"images":1,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Recruitment Test Record of Jupyter Group"]
[]
[null,"Candidate Name","Marks (Preliminary)","Marks (Written)","Marks (Viva)"]
[null,"Jennifer Marlo",82,92,36]
[null,"Frank Orwell",null,45,63]
[null,"Kane Hopkins",97]
[null,"Marcus North",100,72,66]
[null,"Shane Austin",null,57,79]
[null,"Angela Hopkins",68,76,64]
[null,"Natalia Anderson",85,null,100]
[null,"Ross Hayes",63]
[null,"Steve Hopkins",59,100]
[null,"Matthew Shepherd",66,33]

{"sheet":"Sheet1","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,4],[3,6,3,7],[12,7,13,7],[12,6,13,6],[1,1,1,7]]}
[]
[null,"Excel Macro Delete Row If Cell Is Blank"]
[]
[null,"Recruitment Test Record of Jupyter Group",null,null,null,null,"Method Overview"]
[]
[null,"Candidate Name","Marks (Preliminary)","Marks (Written)","Marks (Viva)",null,"Steps","Description"]
[null,"Jennifer Marlo",82,92,36,null,1,"Open VBA window"]
[null,"Frank Orwell",null,45,63,null,2,"Insert New Module"]
[null,"Kane Hopkins",97,null,null,null,3,"Assign VBA Code in Module"]
[null,"Marcus North",100,72,66,null,4,"Save Macro-enabled workbook"]
[null,"Shane Austin",null,57,79,null,5,"Select dataset to delete row"]
[null,"Angela Hopkins",68,76,64,null,6,"Run Macro"]
[null,"Natalia Anderson",85,null,100,null,7,"Enter number of columns with blank cells"]
[null,"Ross Hayes",63]
[null,"Steve Hopkins",59,100]
[null,"Matthew Shepherd",66,33]

{"sheet":"Delete Rows","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Row If Cell Is Blank"]
[]
[null,"Candidate Name","Marks (Preliminary)","Marks (Written)","Marks (Viva)"]
[null,"Jennifer Marlo",82,92,36]
[null,"Marcus North",100,72,66]
[null,"Angela Hopkins",68,76,64]
[null,"Steve Hopkins",59,100]
[null,"Matthew Shepherd",66,33]

{"sheet":"Exercise","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Try Yourself"]
[]
[null,"Candidate Name","Marks (Preliminary)","Marks (Written)","Marks (Viva)"]
[null,"Jennifer Marlo",82,92,36]
[null,"Frank Orwell",null,45,63]
[null,"Kane Hopkins",97]
[null,"Marcus North",100,72,66]
[null,"Shane Austin",null,57,79]
[null,"Angela Hopkins",68,76,64]
[null,"Natalia Anderson",85,null,100]
[null,"Ross Hayes",63]
[null,"Steve Hopkins",59,100]
[null,"Matthew Shepherd",66,33]