{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["example 1.1","example 1.2","example 2","example 3","exmple 4","Dataset"],"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":"example 1.1","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hide Blank Rows in Excel VBA"]
[]
[null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-01","Boston","Bars","Carrot",33,1.77,{"$f":"F5*G5","v":58.410000000000004}]
[null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,303.63]
[null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,null,"New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,"2020-01-13","Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,"2020-01-16","Boston",null,"Carrot",55,1.77,97.35]
[null,"2020-01-19","Boston","Crackers","Whole Wheat",149,3.49,520.01]
[null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,90.27]
[null,"2020-01-25","New York","Bars","Carrot",100,1.77,177]

{"sheet":"example 1.2","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hide Blank Rows in Excel VBA"]
[]
[null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,{"$f":"F5*G5","v":303.63}]
[null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,"2020-01-10","New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,null,"Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,"2020-01-16","Boston","Bars","Carrot",55,1.77,97.35]
[null,"2020-01-19","Boston",null,"Whole Wheat",149,3.49,520.01]
[null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,90.27]
[null,"2020-01-25","New York","Bars","Carrot",100,1.77,177]
[null,"2020-01-28","New York","Snacks","Potato Chips",28,1.35,37.800000000000004]

{"sheet":"example 2","index":2,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hide Blank Rows in Excel VBA"]
[]
[null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,{"$f":"F5*G5","v":303.63}]
[null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,"2020-01-10","New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,null,"Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,"2020-01-16","Boston","Bars","Carrot",55,1.77,97.35]
[]
[null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,90.27]
[]
[null,"2020-01-25","New York","Bars","Carrot",100,1.77,177]
[null,"2020-01-28","New York","Snacks","Potato Chips",28,1.35,{"$f":"F14*G14","v":37.800000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,{"$f":"Q17*R17","v":303.63}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-10","New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-16","Boston","Bars","Carrot",55,1.77,97.35]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,{"$f":"Q23*R23","v":90.27}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-25","New York","Bars","Carrot",100,1.77,{"$f":"Q25*R25","v":177}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-28","New York","Snacks","Potato Chips",28,1.35,{"$f":"Q26*R26","v":37.800000000000004}]

{"sheet":"example 3","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hide Blank Rows in Excel VBA"]
[]
[null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,{"$f":"F5*G5","v":303.63}]
[null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,"2020-01-10","New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,null,"Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,"2020-01-16","Boston","Bars","Carrot",55,1.77,97.35]
[]
[null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,90.27]
[]
[null,"2020-01-25","New York","Bars","Carrot",100,1.77,177]
[null,"2020-01-28","New York","Snacks","Potato Chips",28,1.35,{"$f":"F14*G14","v":37.800000000000004}]

{"sheet":"exmple 4","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,{"$f":"F3*G3","v":303.63}]
[null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,"2020-01-10","New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,null,"Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,"2020-01-16","Boston","Bars","Carrot",55,1.77,97.35]
[null,"2020-01-19","Boston","Crackers","Whole Wheat",149,3.49,520.01]
[null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,90.27]
[null,"2020-01-25","New York","Bars","Carrot",100,1.77,177]
[null,"2020-01-28","New York","Snacks","Potato Chips",28,1.35,37.800000000000004]

{"sheet":"Dataset","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hide Blank Rows in Excel VBA"]
[]
[null,"OrderDate","City","Category","Product","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Boston","Crackers","Whole Wheat",87,3.49,{"$f":"F5*G5","v":303.63}]
[null,"2020-01-07","Los Angeles","Cookies","Chocolate Chip",58,1.87,108.46000000000001]
[null,"2020-01-10","New York","Cookies","Chocolate Chip",82,1.87,153.34]
[null,"2020-01-13","Boston","Cookies","Arrowroot",38,2.1800000000000002,82.84]
[null,"2020-01-16","Boston","Bars","Carrot",55,1.77,97.35]
[null,"2020-01-19","Boston","Crackers","Whole Wheat",149,3.49,520.01]
[null,"2020-01-22","Los Angeles","Bars","Carrot",51,1.77,90.27]
[null,"2020-01-25","New York","Bars","Carrot",100,1.77,177]
[null,"2020-01-28","New York","Snacks","Potato Chips",28,1.35,37.800000000000004]