{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Reference style","Functions","VBA macros"],"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":"Reference style","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Change Column Name from ABC to 123"]
[]
[null,"ID","Salesman","Sales"]
[null,1,"Mike",100]
[null,2,"Adam",200]
[null,3,"Stuart",300]
[null,4,"Bob",340]
[null,5,"Lilly",230]

{"sheet":"Functions","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use Match, Address & Column Function to Change Column Name"]
[]
[null,"Column Letter","Column Number"]
[null,"A",{"$f":"MATCH(B5&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":1}]
[null,"Z",{"$f":"MATCH(B6&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":26}]
[null,"AB",{"$f":"MATCH(B7&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":28}]
[null,"ABB",{"$f":"MATCH(B8&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":730}]
[null,"AXZ",{"$f":"MATCH(B9&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":1326}]

{"sheet":"VBA macros","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Change Column Name from ABC to 123 Using VBA Macro"]
[]
[null,"ID","Salesman","Sales"]
[null,1,"Mike",100]
[null,2,"Adam",200]
[null,3,"Stuart",300]
[null,4,"Bob",340]
[null,5,"Lilly",230]