{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["dataset1","dataset2","dataset3","Single","multiple","active","Selection","empty cell","empty row","nth row","cell value","duplicate","Table","Filter","last active","String","Date","Practice","Sheet16"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"dataset1","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"XYZ\" Company"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Shoe 1",6.5,1750]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"dataset2","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"ABC\" Company"]
[]
[null,"Product Code","Product Size","Price"]
[null,73600,"L",1750]
[null,97375,"XXL",1870]
[null,64872,9,1750]
[null,48270,8,4500]
[null,66531,6,3500]
[null,97375,"XXL",1870]
[null,96371,"XL",1200]
[null,92273,5,1230]
[null,85914,8,1100]

{"sheet":"dataset3","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," \"X\" Construction Company"]
[]
[null,"Project","Start Date","Cost"]
[null,"Aspen Dental","2021-11-12",42953]
[null,"Dairy Queen Restaurant","2021-12-09",21108]
[null,"Hobby Lobby","2021-11-29",34354]
[null,"Yellow Retirement Community","2021-12-05",44058]
[null,"Jos A Bank","2021-11-12",47755]
[null,"Wings","2021-11-27",44994]

{"sheet":"Single","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Single Row"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"multiple","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Multiple Rows"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]

{"sheet":"active","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Row with Respect to Active Cell"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"Selection","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting all rows in the selection"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"empty cell","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Row with Empty cell"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Shoe 1",6.5,1750]
[null,"Jacket 1","L",4500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"empty row","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Empty Row"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Shoe 1",6.5,1750]
[null,"Jacket 1","L",4500]
[null,null,"XL",3500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Shoe 3",7.5,1100]

{"sheet":"nth row","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting nth row"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]

{"sheet":"cell value","index":10,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Row Based On Cell Value"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shoe 1",6.5,1750]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"duplicate","index":11,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Duplicate Rows"]
[]
[null,"Product Code","Product Size","Price"]
[null,73600,"L",1750]
[null,97375,"XXL",1870]
[null,64872,9,1750]
[null,48270,8,4500]
[null,66531,6,3500]
[null,96371,"XL",1200]
[null,92273,5,1230]
[null,85914,8,1100]

{"sheet":"Table","index":12,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Rows in a Table"]
[]
[null,"Product Code","Product Size","Price"]
[null,73600,"L",1750]
[null,97375,"XXL",1870]
[null,64872,9,1750]
[null,48270,8,4500]
[null,66531,6,3500]
[null,96371,"XL",1200]
[null,92273,5,1230]
[null,85914,8,1100]

{"sheet":"Filter","index":13,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Filtered Rows"]
[]
[null,"Product Code","Product Size","Price"]
[null,96371,"XL",1200]
[null,92273,5,1230]
[null,85914,8,1100]

{"sheet":"last active","index":14,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Last Active Cell"]
[]
[null,"Product Code","Product Size","Price"]
[null,73600,"L",1750]
[null,97375,"XXL",1870]
[null,64872,9,1750]
[null,48270,8,4500]
[null,66531,6,3500]
[null,97375,"XXL",1870]
[null,96371,"XL",1200]
[null,92273,5,1230]

{"sheet":"String","index":15,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting rows with string"]
[]
[null,"Product Code","Product Size","Price"]
[null,64872,9,1750]
[null,48270,8,4500]
[null,66531,6,3500]
[null,92273,5,1230]
[null,85914,8,1100]

{"sheet":"Date","index":16,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Rows with Specific Dates"]
[]
[null,"Project","Start Date","Cost"]
[null,"Dairy Queen Restaurant","2021-12-09",21108]
[null,"Hobby Lobby","2021-11-29",34354]
[null,"Yellow Retirement Community","2021-12-05",44058]
[null,"Wings","2021-11-27",44994]

{"sheet":"Practice","index":17,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7],[1,9,1,11]]}
[]
[null,"Practice",null,null,null,"Practice",null,null,null,"Practice"]
[]
[null,"Product","Size","Price",null,"Product Code","Product Size","Price",null,"Project","Start Date","Cost"]
[null,"Shirt 1","L",1750,null,73600,"L",1750,null,"Aspen Dental","2021-11-12",42953]
[null,"Shirt 2","XXL",1870,null,97375,"XXL",1870,null,"Dairy Queen Restaurant","2021-12-09",21108]
[null,"Shoe 1",6.5,1750,null,64872,9,1750,null,"Hobby Lobby","2021-11-29",34354]
[null,"Jacket 1","L",4500,null,48270,8,4500,null,"Yellow Retirement Community","2021-12-05",44058]
[null,"Jacket 2","XL",3500,null,66531,6,3500,null,"Jos A Bank","2021-11-12",47755]
[null,"Shoe 2",7,5500,null,97375,"XXL",1870,null,"Wings","2021-11-27",44994]
[null,"Pant 1","XL",1200,null,96371,"XL",1200]
[null,"Pant 2","XXL",1230,null,92273,5,1230]
[null,"Shoe 3",7.5,1100,null,85914,8,1100]

{"sheet":"Sheet16","index":18,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Deleting Rows"]
[]
[null,"Product","Size","Price",null,"Product","Size","Price"]
[null,"Shirt 1","L",1750,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,null,"Shirt 2","XXL",1870]
[null,"Shoe 1",6.5,1750,null,"Jacket 1","L",4500]
[null,"Jacket 1","L",4500,null,"Jacket 2","XL",3500]
[null,"Jacket 2","XL",3500,null,"Pant 1","XL",1200]
[null,"Shoe 2",7,5500,null,"Pant 2","XXL",1230]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]