{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sales","Without Space","Sales Data","With Space","Sales_Data","Sheet_List","VBA_Code","Sales Data Header","Sales Data Footer"],"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":"Sales","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Find Current Sheet Name",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","January","February","March",null,null,"Name","January","February","March"]
[null,"John",1500,1800,1200,null,null,"John",1500,1800,1200]
[null,"Chris",2000,2500,2600,null,null,"Chris",2000,2500,2600]
[null,"Jessica",1200,1500,1900,null,null,"Jessica",1200,1500,1900]
[null,"Lisa",1400,2300,2000,null,null,"Lisa",1400,2300,2000]
[null,"Eevan",1600,2200,1400,null,null,"Eevan",1600,2200,1400]
[null,"Tony",2500,1700,1200,null,null,"Tony",2500,1700,1200]
[]
[null,null,"Sheet Name",{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Sales"},null,null,null,null,"Sheet Name"]

{"sheet":"Without Space","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Sheet Name without Space or Punctuation",null,null,null,null,"Practice Yourself"]
[]
[null,"Sheet Name","Total Sales in January","Total Sales in February",null,null,"Sheet Name","Total Sales in January","Total Sales in February"]
[null,"Sales",{"$f":"SUM(INDIRECT(B5&\"!C5:C10\"))","v":10200},{"$f":"SUM(INDIRECT(B5&\"!D5:D10\"))","v":12000},null,null,"Sales"]

{"sheet":"Sales Data","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Get Sheet Name with Space or Punctuation",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","January","February","March",null,null,"Name","January","February","March"]
[null,"John",1500,1800,1200,null,null,"John",1500,1800,1200]
[null,"Chris",2000,2500,2600,null,null,"Chris",2000,2500,2600]
[null,"Jessica",1200,1500,1900,null,null,"Jessica",1200,1500,1900]
[null,"Lisa",1400,2300,2000,null,null,"Lisa",1400,2300,2000]
[null,"Eevan",1600,2200,1400,null,null,"Eevan",1600,2200,1400]
[null,"Tony",2500,1700,1200,null,null,"Tony",2500,1700,1200]
[]
[null,null,"Sheet Name",{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Sales Data"},null,null,null,null,"Sheet Name"]

{"sheet":"With Space","index":3,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Sheet Name with Space",null,null,null,null,"Practice Yourself"]
[]
[null,"Sheet Name","Total Sales in January","Total Sales in February",null,null,"Sheet Name","Total Sales in January","Total Sales in February"]
[null,"Sales Data",{"$f":"SUM(INDIRECT(\"'\"&B5&\"'!C5:C10\"))","v":10200},{"$f":"SUM(INDIRECT(\"'\"&B5&\"'!D5:D10\"))","v":12000},null,null,"Sales Data"]

{"sheet":"Sales_Data","index":4,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Use VBA to Get Active Sheet Name",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","January","February","March",null,null,"Name","January","February","March"]
[null,"John",1500,1800,1200,null,null,"John",1500,1800,1200]
[null,"Chris",2000,2500,2600,null,null,"Chris",2000,2500,2600]
[null,"Jessica",1200,1500,1900,null,null,"Jessica",1200,1500,1900]
[null,"Lisa",1400,2300,2000,null,null,"Lisa",1400,2300,2000]
[null,"Eevan",1600,2200,1400,null,null,"Eevan",1600,2200,1400]
[null,"Tony",2500,1700,1200,null,null,"Tony",2500,1700,1200]
[]
[null,null,"Sheet Name","Sales_Data",null,null,null,null,"Sheet Name"]

{"sheet":"Sheet_List","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Sales"]
[null,"Without Space"]
[null,"Sales Data"]
[null,"With Space"]
[null,"Sales_Data"]
[null,"Sheet_List"]
[null,"Code"]
[null,"Sales Data Header"]
[null,"Sales Data Footer"]

{"sheet":"VBA_Code","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of CodeName"]
[]
[null,"Name","January","February","March"]
[null,"John",1500,1800,1200]
[null,"Chris",2000,2500,2600]
[null,"Jessica",1200,1500,1900]
[null,"Lisa",1400,2300,2000]
[null,"Eevan",1600,2200,1400]
[null,"Tony",2500,1700,1200]

{"sheet":"Sales Data Header","index":7,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,1,20,4],[1,2,1,5]]}
[]
[null,null,"Input Sheet Name in Header"]
[]
[null,null,"Name","January","February","March"]
[null,null,"John",1500,1800,1200]
[null,null,"Chris",2000,2500,2600]
[null,null,"Jessica",1200,1500,1900]
[null,null,"Lisa",1400,2300,2000]
[null,null,"Eevan",1600,2200,1400]
[null,null,"Tony",2500,1700,1200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input Sheet Name in Header"]
[]
[null,"Name","January","February","March"]
[null,"John",1500,1800,1200]
[null,"Chris",2000,2500,2600]
[null,"Jessica",1200,1500,1900]
[null,"Lisa",1400,2300,2000]
[null,"Eevan",1600,2200,1400]
[null,"Tony",2500,1700,1200]

{"sheet":"Sales Data Footer","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Input Sheet Name in Footer"]
[]
[null,"Name","January","February","March"]
[null,"John",1500,1800,1200]
[null,"Chris",2000,2500,2600]
[null,"Jessica",1200,1500,1900]
[null,"Lisa",1400,2300,2000]
[null,"Eevan",1600,2200,1400]
[null,"Tony",2500,1700,1200]