{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Delete any cell","Specific Value","Range","Deleting One Column","Deleting Multiple Columns","Columns Based on a Cell Value","Blank Columns","Delete One Row","Delete Rows for Specific Value"],"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":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Information of ABC Car Company"]
[]
[null,"Car Name","Manufacturer","Model","Year","Price"]
[null,"Accord","Honda","LX",2022,26000]
[null,"Civic","Honda","EX",2021,24000]
[null,"Camry","Toyota","LE",2022,28000]
[null,"Corolla","Toyota","SE",2021,22000]
[null,"Sentra","Nissan","SV",2022,20000]
[null,"Altima","Nissan","S",2021,26000]
[null,"Sonata","Hyundai","SEL",2022,27000]
[null,"Elantra","Hyundai","SE",2021,23000]
[null,"Accord","Honda","Sport",2020,20000,null,null," "]
[null,"Camry","Toyota","XSE",2020,32000]
[null,"Corolla","Toyota","SE",2022,23000]
[null,"Versa","Nissan","SR",2021,19000]
[null,"Kona","Hyundai","SEL",2022,24000]

{"sheet":"Delete any cell","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Delete and Shift Left Cell for Any Value"]
[]
[null,"Car Name","Manufacturer","Model","Year","Price"]
[null,"Accord","Honda","LX",2022,26000]
[null,"Civic","Honda","EX",2021,24000]
[null,"Camry","Toyota","LE",2022,28000]
[null,"Corolla","Toyota","SE",2021,22000]
[null,"Sentra","Nissan","SV",2022,20000]
[null,"Altima","Nissan","S",2021,26000]
[null,"Sonata","Hyundai","SEL",2022,27000]
[null,"Elantra","Hyundai","SE",2021,23000]
[null,"Accord","Honda","Sport",2020,20000]
[null,"Camry","Toyota","XSE",2020,32000]
[null,"Corolla","Toyota","SE",2022,23000]
[null,"Versa","Nissan","SR",2021,19000]
[null,"Kona","Hyundai","SEL",2022,24000]

{"sheet":"Specific Value","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete and Shift Left For a Specific Value"]
[]
[null,"Car Name","Manufacturer"]
[null,"Accord","Nissan"]
[null,"Civic","Nissan"]
[null,"Camry","Toyota"]
[null,"Corolla","Toyota"]
[null,"Sentra","Nissan"]
[null,"Altima","Nissan"]
[null,"Sonata","Hyundai"]
[null,"Elantra","Hyundai"]
[null,"Accord","Nissan"]
[null,"Camry","Toyota"]
[null,"Corolla Hatchback","Toyota"]
[null,"Versa","Nissan"]
[null,"Kona","Hyundai"]

{"sheet":"Range","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Delete and Shift Left for Range of Cells"]
[]
[null,"Car Name","Manufacturer","Model","Year","Price"]
[null,"Accord","Honda","LX",2022,26000]
[null,"Civic","Honda","EX",2021,24000]
[null,"Camry","Toyota","LE",2022,28000]
[null,"Corolla","Toyota","SE",2021,22000]
[null,"Sentra","Nissan","SV",2022,20000]
[null,"Altima","Nissan","S",2021,26000]
[null,"Sonata","Hyundai","SEL",2022,27000]
[null,"Elantra","Hyundai","SE",2021,23000]
[null,"Accord","Honda","Sport",2020,20000]
[null,"Camry","Toyota","XSE",2020,32000]
[null,"Corolla Hatchback","Toyota","SE",2022,23000]
[null,"Versa","Nissan","SR",2021,19000]
[null,"Kona","Hyundai","SEL",2022,24000]

{"sheet":"Deleting One Column","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Delete and Shift Left for One Column"]
[]
[null,"Car Name","Manufacturer","Year","Price"]
[null,"Accord","Honda",2022,26000]
[null,"Civic","Honda",2021,24000]
[null,"Camry","Toyota",2022,28000]
[null,"Corolla","Toyota",2021,22000]
[null,"Sentra","Nissan",2022,20000]
[null,"Altima","Nissan",2021,26000]
[null,"Sonata","Hyundai",2022,27000]
[null,"Elantra","Hyundai",2021,23000]
[null,"Accord","Honda",2020,20000]
[null,"Camry","Toyota",2020,32000]
[null,"Corolla Hatchback","Toyota",2022,23000]
[null,"Versa","Nissan",2021,19000]
[null,"Kona","Hyundai",2022,24000]

{"sheet":"Deleting Multiple Columns","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete and Shift Left for Multiple Columns"]
[]
[null,"Car Name","Manufacturer","Price"]
[null,"Accord","Honda",26000]
[null,"Civic","Honda",24000]
[null,"Camry","Toyota",28000]
[null,"Corolla","Toyota",22000]
[null,"Sentra","Nissan",20000]
[null,"Altima","Nissan",26000]
[null,"Sonata","Hyundai",27000]
[null,"Elantra","Hyundai",23000]
[null,"Accord","Honda",20000]
[null,"Camry","Toyota",32000]
[null,"Corolla Hatchback","Toyota",23000]
[null,"Versa","Nissan",19000]
[null,"Kona","Hyundai",24000]

{"sheet":"Columns Based on a Cell Value","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Delete and Shift Left Columns Based on Cell Value"]
[]
[null,"Car Name","Manufacturer","Year","Price"]
[null,"Accord","Honda",2022,26000]
[null,"Civic","Honda",2021,24000]
[null,"Camry","Toyota",2022,28000]
[null,"Corolla","Toyota",2021,22000]
[null,"Sentra","Nissan",2022,20000]
[null,"Altima","Nissan",2021,26000]
[null,"Sonata","Hyundai",2022,27000]
[null,"Elantra","Hyundai",2021,23000]
[null,"Accord","Honda",2020,20000]
[null,"Camry","Toyota",2020,32000]
[null,"Corolla Hatchback","Toyota",2022,23000]
[null,"Versa","Nissan",2021,19000]
[null,"Kona","Hyundai",2022,24000]

{"sheet":"Blank Columns","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Delete and Shift Left for Blank Cells"]
[]
[null,"Car Name","Model","Year","Price"]
[null,"Accord","LX",2022,26000]
[null,"Civic","EX",2021,24000]
[null,"Camry","LE",2022,28000]
[null,"Corolla","SE",2021,22000]
[null,"Sentra","SV",2022,20000]
[null,"Altima","S",2021,26000]
[null,"Sonata","SEL",2022,27000]
[null,"Elantra","SE",2021,23000]
[null,"Accord","Sport",2020,20000]
[null,"Camry","XSE",2020,32000]
[null,"Corolla Hatchback","SE",2022,23000]
[null,"Versa","SR",2021,19000]
[null,"Kona","SEL",2022,24000]

{"sheet":"Delete One Row","index":8,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Delete and Shift Up One Row"]
[]
[null,"Car Name","Manufacturer","Model","Year","Price"]
[null,"Accord","Honda","LX",2022,26000]
[null,"Civic","Honda","EX",2021,24000]
[null,"Camry","Toyota","LE",2022,28000]
[null,"Corolla","Toyota","SE",2021,22000]
[null,"Altima","Nissan","S",2021,26000]
[null,"Sonata","Hyundai","SEL",2022,27000]
[null,"Elantra","Hyundai","SE",2021,23000]
[null,"Accord","Honda","Sport",2020,20000]
[null,"Camry","Toyota","XSE",2020,32000]
[null,"Corolla Hatchback","Toyota","SE",2022,23000]
[null,"Versa","Nissan","SR",2021,19000]
[null,"Kona","Hyundai","SEL",2022,24000]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Delete Rows for Specific Value","index":9,"n_rows":21,"n_cols":20,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Delete Entire Rows and Shift Up for Specific Value"]
[]
[null,"Car Name","Manufacturer","Model","Year","Price"]
[null,"Accord","Honda","LX",2022,26000]
[null,"Civic","Honda","EX",2021,24000]
[null,"Camry","Toyota","LE",2022,28000]
[null,"Corolla","Toyota","SE",2021,22000]
[null,"Sentra","Nissan","SV",2022,20000]
[null,"Altima","Nissan","S",2021,26000]
[null,"Sonata","Hyundai","SEL",2022,27000]
[null,"Elantra","Hyundai","SE",2021,23000]
[null,"Accord","Honda","Sport",2020,20000]
[null,"Camry","Toyota","XSE",2020,32000]
[null,"Corolla Hatchback","Toyota","SE",2022,23000]
[null,"Versa","Nissan","SR",2021,19000]
[null,"Kona","Hyundai","SEL",2022,24000]
[null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]