{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Datasheet","Field Number","Range","Table","Source","Pivot","Header"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Datasheet","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"\"XYZ\" Company"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",4280]
[null,"Apricots","East",4804]
[null,"Banana","South",2476]
[null,"Blackberries","North",2212]
[null,"Blueberries","West",3930]
[null,"Cherries","East",2227]
[null,"Clementine","South",2511]
[null,"Tomatoes","East",1500]

{"sheet":"Field Number","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Problems Due to Incorrect Field Number"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",4280]
[null,"Apricots","East",4804]
[null,"Banana","South",2476]
[null,"Blackberries","North",2212]
[null,"Blueberries","West",3930]
[null,"Cherries","East",2227]
[null,"Clementine","South",2511]
[null,"Tomatoes","East",1500]

{"sheet":"Range","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using Correct Range"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",4280]
[null,"Apricots","East",4804]
[null,"Banana","South",2476]
[null,"Blackberries","North",2212]
[null,"Blueberries","West",3930]
[null,"Cherries","East",2227]
[null,"Clementine","South",2511]
[null,"Tomatoes","East",1500]

{"sheet":"Table","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Filtering Table Issue"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",4280]
[null,"Apricots","East",4804]
[null,"Banana","South",2476]
[null,"Blackberries","North",2212]
[null,"Blueberries","West",3930]
[null,"Cherries","East",2227]
[null,"Clementine","South",2511]
[null,"Tomatoes","East",1500]

{"sheet":"Source","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Pivot Table Issue"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",4280]
[null,"Apricots","East",4804]
[null,"Banana","South",2476]
[null,"Blackberries","North",2212]
[null,"Blueberries","West",3930]
[null,"Cherries","East",2227]
[null,"Clementine","South",2511]
[null,"Tomatoes","East",1500]

{"sheet":"Pivot","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Pivot Table Issue"]
[]
["Row Labels","Sum of Sales"]
["East",8531]
["Apricots",4804]
["Cherries",2227]
["Tomatoes",1500]
["North",6492]
["Apple",4280]
["Blackberries",2212]
["South",4987]
["Banana",2476]
["Clementine",2511]
["West",3930]
["Blueberries",3930]
["Grand Total",23940]

{"sheet":"Header","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Setting Range as Header"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",4280]
[null,"Apricots","East",4804]
[null,"Banana","South",2476]
[null,"Blackberries","North",2212]
[null,"Blueberries","West",3930]
[null,"Cherries","East",2227]
[null,"Clementine","South",2511]
[null,"Tomatoes","East",1500]