{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Header Name","without Header","Insert Row","Intersect","Replace","Display","Delete"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Table Column by Name with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"Header Name","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Table Column by Header Name with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"without Header","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Table Column by Header Name without Header"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"Insert Row","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Insert Row by Reference of Table Column Header"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]
[null,"Steve",111,88]

{"sheet":"Intersect","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Insert Row by Reference of Table Column Header"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]
[null,"Steve",111,88]

{"sheet":"Replace","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Replace Row Value by Header Name with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Rollins",112,75]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"Display","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Display Value by Header Name with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"Delete","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete an Entire Row by Header Name with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]