{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Certain Rows","DefinedRange","InputBox","Sheet1","Sheet2","Sheet3"],"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,"Dataset to Delete Row If Cell Contains 0"]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",58]
[null,"Site 2","2022-03-02",0]
[null,"Site 3","2022-03-03",722]
[null,"Site 4","2022-03-04",0]
[null,"Site 5","2022-03-05",936]
[null,"Site 6","2022-03-06",143]
[null,"Site 7","2022-03-07",23]
[null,"Site 8","2022-03-08",0]
[null,"Site 9","2022-03-09",136]
[null,"Site 10","2022-03-10",0]

{"sheet":"Certain Rows","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Macro to Delete Certain Rows If Cell Contains 0"]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",58]
[null,"Site 3","2022-03-03",722]
[null,"Site 5","2022-03-05",936]
[null,"Site 6","2022-03-06",143]
[null,"Site 7","2022-03-07",23]
[null,"Site 9","2022-03-09",136]

{"sheet":"DefinedRange","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete Entire Row from Defined Range"]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",58]
[null,"Site 3","2022-03-03",722]
[null,"Site 5","2022-03-05",936]
[null,"Site 6","2022-03-06",143]
[null,"Site 7","2022-03-07",23]
[null,"Site 9","2022-03-09",136]

{"sheet":"InputBox","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using InputBox for Defining Range "]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",58]
[null,"Site 3","2022-03-03",722]
[null,"Site 5","2022-03-05",936]
[null,"Site 6","2022-03-06",143]
[null,"Site 7","2022-03-07",23]
[null,"Site 9","2022-03-09",136]

{"sheet":"Sheet1","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete Row If Cell Contains 0 across Multiple Sheets"]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",58]
[null,"Site 3","2022-03-03",722]
[null,"Site 5","2022-03-05",936]
[null,"Site 6","2022-03-06",143]
[null,"Site 7","2022-03-07",23]
[null,"Site 9","2022-03-09",136]

{"sheet":"Sheet2","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete Row If Cell Contains 0 across Multiple Sheets"]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",75]
[null,"Site 3","2022-03-03",832]
[null,"Site 5","2022-03-05",136]
[null,"Site 6","2022-03-06",243]
[null,"Site 7","2022-03-07",333]
[null,"Site 9","2022-03-09",156]

{"sheet":"Sheet3","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete Row If Cell Contains 0 across Multiple Sheets"]
[]
[null,"Name of Sites","Date","Number of Visits"]
[null,"Site 1","2022-03-01",85]
[null,"Site 3","2022-03-03",232]
[null,"Site 5","2022-03-05",536]
[null,"Site 6","2022-03-06",251]
[null,"Site 7","2022-03-07",451]
[null,"Site 9","2022-03-09",196]