{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Replace","Go To","Pivot","VBA","0 or Dash"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store- 2022"]
[]
[null,"Seller","Month","Product","Quantity","Amount"]
[null,"Sam","Apr","Banana",1565]
[null,"Sam",null,"Mango",null,5062]
[null,"Sofia","Jan",null,5432,6216]
[null,"Melissa",null,"Mango",5631]
[null,"Afra","Mar",null,8462]
[null,"Sofia",null,null,6542]
[null,"Afra","Apr","Orange",null,3697]
[null,"Total"]

{"sheet":"Replace","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store- 2022"]
[]
[null,"Seller","Month","Product","Quantity","Amount"]
[null,"Sam","Apr","Banana",1565,"NA"]
[null,"Sam","NA","Mango","NA",5062]
[null,"Sofia","Jan","NA",5432,6216]
[null,"Melissa","NA","Mango",5631,"NA"]
[null,"Afra","Mar","NA",8462,"NA"]
[null,"Sofia","NA","NA",6542,"NA"]
[null,"Afra","Apr","Orange","NA",3697]
[null,"Total"]

{"sheet":"Go To","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store- 2022"]
[]
[null,"Seller","Month","Product","Quantity","Amount"]
[null,"Sam","Apr","Banana",1565,"NA"]
[null,"Sam",null,"Mango",null,5062]
[null,"Sofia","Jan",null,5432,6216]
[null,"Melissa",null,"Mango",5631]
[null,"Afra","Mar",null,8462]
[null,"Sofia",null,null,6542]
[null,"Afra","Apr","Orange",null,3697]
[null,"Total"]

{"sheet":"Pivot","index":3,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Quantity","Sum of Amount"]
["Jan",5432,6216]
["Mar",8462,"NA"]
["Afra",8462,"NA"]
["(blank)",8462,"NA"]
["Apr",1565,3697]
["Afra","NA",3697]
["Orange","NA",3697]
["Sam",1565,"NA"]
["Banana",1565,"NA"]
["(blank)",12173,5062]
["Melissa",5631,"NA"]
["Mango",5631,"NA"]
["Sam","NA",5062]
["Mango","NA",5062]
["Sofia",6542,"NA"]
["(blank)",6542,"NA"]
["Grand Total",27632,14975]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store- 2022"]
[]
[null,"Seller","Month","Product","Quantity","Amount"]
[null,"Sam","Apr","Banana",1565]
[null,"Sam",null,"Mango",null,5062]
[null,"Sofia","Jan",null,5432,6216]
[null,"Melissa",null,"Mango",5631]
[null,"Afra","Mar",null,8462]
[null,"Sofia",null,null,6542]
[null,"Afra","Apr","Orange",null,3697]
[null,"Total"]

{"sheet":"0 or Dash","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store- 2022"]
[]
[null,"Seller","Month","Product","Quantity","Amount"]
[null,"Sam","Apr","Banana",1565,0]
[null,"Sam",0,"Mango",0,5062]
[null,"Sofia","Jan",0,5432,6216]
[null,"Melissa",0,"Mango",5631,0]
[null,"Afra","Mar",0,8462,0]
[null,"Sofia",0,0,6542,0]
[null,"Afra","Apr","Orange",0,3697]
[null,"Total"]