{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Whole Sheet","Continuous Data","One Column","Specific Word"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"Whole Sheet","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA to Count Rows with Data in Whole Sheet"]
[]
[null,"Student","ID","Age"]
[null,"Sam",2022001,15]
[null,"Peter",2022002,13]
[null,"Jack",2022003,14]
[null,"Samuel",2022004,16]
[null,"Willium",2022005,14]
[null,"Ron",2022006,17]
[null,"Bob",2022007,15]

{"sheet":"Continuous Data","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA to Count Used Rows for Continuous Data"]
[]
[null,"Student","ID","Age"]
[null,"Sam",2022001,15]
[null,"Peter",2022002,13]
[null,"Jack",2022003,14]
[null,"Samuel",2022004,16]
[null,"Willium",2022005,14]
[null,"Ron",2022006,17]
[null,"Bob",2022007,15]

{"sheet":"One Column","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA to Count Used Rows for One Column"]
[]
[null,"Student","ID","Age"]
[null,"Sam",2022001,15]
[null,"Peter",2022002,13]
[null,"Jack",2022003,14]
[]
[null,"Willium",2022005,14]
[null,"Ron",2022006,17]
[null,"Bob",2022007,15]

{"sheet":"Specific Word","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA to Count Used Rows with Specific Word"]
[]
[null,"Student","ID","Age"]
[null,"Sam",2022001,15]
[null,"Peter",2022002,13]
[null,"Jack",2022003,15]
[null,"Samuel",2022004,16]
[null,"Willium",2022005,14]
[null,"Ron",2022006,17]
[null,"Bob",2022007,15]