{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset Overview","Using Excel Formula","Use of Paste Special Option","Using VBA Code","Adding Text to Existing Cell"],"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 Overview","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee ID","Salary","Bonus"]
[null,1,5000,2000]
[null,2,5500,2000]
[null,3,4500,1500]
[null,4,6000,2500]
[null,5,4000,1500]
[null,6,4800,2000]

{"sheet":"Using Excel Formula","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Excel Formula"]
[]
[null,"Employee ID","Salary","Bonus","New Salary"]
[null,1,5000,2000,{"$f":"C5+100","v":5100}]
[null,2,5500,2000]
[null,3,4500,1500]
[null,4,6000,2500]
[null,5,4000,1500]
[null,6,4800,2000]
[]
[null,null,null,null,null,null,null,"`"]

{"sheet":"Use of Paste Special Option","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Paste Special Option"]
[]
[null,"Employee ID","Salary","Bonus"]
[null,1,5100,2000,100]
[null,2,5600,2000]
[null,3,4600,1500]
[null,4,6100,2500]
[null,5,4100,1500]
[null,6,4900,2000]

{"sheet":"Using VBA Code","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Employee ID","Salary","Bonus"]
[null,1,5300,2000]
[null,2,5800,2000]
[null,3,4800,1500]
[null,4,6300,2500]
[null,5,4300,1500]
[null,6,5100,2000]
[]
[null,null,null,null,null,null,null,"`"]

{"sheet":"Adding Text to Existing Cell","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding Text to Existing Cell Value"]
[]
[null,"Employee ID","Salary","Bonus","New ID"]
[null,1,5000,2000,{"$f":"CONCATENATE(B5,\"A\")","v":"1A"}]
[null,2,5500,2000,{"$f":"CONCATENATE(B6,\"A\")","v":"2A"}]
[null,3,4500,1500,"3A"]
[null,4,6000,2500,"4A"]
[null,5,4000,1500,"5A"]
[null,6,4800,2000,"6A"]
[]
[null,null,null,null,null,null,null,"`"]