{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Clearing Single Cell","Clearing Range of Cells","Cells from Selection","ClearContent Method","ClearFormats Method","ClearComments Method","ClearHyperlinks Method","Clear Cell Color","Clear All Cells"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Clearing Cells in Excel VBA"]
[]
[null,"Product","Sales"]
[null,"Laptop",11000]
[null,"Mouse",13000]
[null,"Monitor",14000]
[null,"Battery",10000]
[null,"Printer",15000]

{"sheet":"Clearing Single Cell","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Clearing Single Cell",null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,null,null,null,null,"Mouse",13000]
[null,"Monitor",14000,null,null,null,null,null,null,null,null,"Monitor",14000]
[null,"Battery",10000,null,null,null,null,null,null,null,null,"Battery",10000]
[null,"Printer",null,null,null,null,null,null,null,null,null,"Printer",15000]

{"sheet":"Clearing Range of Cells","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Clearing Range of Cells",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,null,"Mouse",13000]
[null,null,null,null,null,null,null,null,"Monitor",14000]
[null,null,null,null,null,null,null,null,"Battery",10000]
[null,null,null,null,null,null,null,null,"Printer",15000]

{"sheet":"Cells from Selection","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Clearing Cells from Selection",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,null,"Mouse",13000]
[null,"Monitor",14000,null,null,null,null,null,"Monitor",14000]
[null,"Battery",10000,null,null,null,null,null,"Battery",10000]
[null,"Printer",15000,null,null,null,null,null,"Printer",15000]

{"sheet":"ClearContent Method","index":4,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Applying ClearContents Method",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,null,"Mouse",13000]
[null,null,null,null,null,null,null,null,"Monitor",14000]
[null,null,null,null,null,null,null,null,"Battery",10000]
[null,null,null,null,null,null,null,null,"Printer",15000]

{"sheet":"ClearFormats Method","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using ClearFormats Method",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,"Mouse",13000]
[null,"Monitor",14000,null,null,null,null,"Monitor",14000]
[null,"Battery",10000,null,null,null,null,"Battery",10000]
[null,"Printer",15000,null,null,null,null,"Printer",15000]

{"sheet":"ClearComments Method","index":6,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Clearing Comments from Cells",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,null,"Mouse",13000]
[null,"Monitor",14000,null,null,null,null,null,"Monitor",14000]
[null,"Battery",10000,null,null,null,null,null,"Battery",10000]
[null,"Printer",15000,null,null,null,null,null,"Printer",15000]

{"sheet":"ClearHyperlinks Method","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Clearing Hyperlinks from Cells",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sheet  Name",null,null,null,null,null,"Sheet  Name"]
[null,"Clearing Single Cell",null,null,null,null,null,"Clearing Single Cell"]
[null,"Clearing Range of Cells",null,null,null,null,null,"Clearing Range of Cells"]
[null,"ClearFormats Method",null,null,null,null,null,"ClearFormats Method"]
[null,"ClearComments Method",null,null,null,null,null,"ClearComments Method"]
[null,"Clear Cell Color",null,null,null,null,null,"Clear Cell Color"]

{"sheet":"Clear Cell Color","index":8,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Clearing Cell Color",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales",null,null,null,null,null,"Product","Sales"]
[null,"Laptop",11000,null,null,null,null,null,"Laptop",11000]
[null,"Mouse",13000,null,null,null,null,null,"Mouse",13000]
[null,"Monitor",14000,null,null,null,null,null,"Monitor",14000]
[null,"Battery",10000,null,null,null,null,null,"Battery",10000]
[null,"Printer",15000,null,null,null,null,null,"Printer",15000]

{"sheet":"Clear All Cells","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}