{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Pivot_Sheet","Sample Data","Pivot","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":"Pivot_Sheet","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Gross Pay"]
["Florance",1689]
["Hollis",2431]
["Ilene",2264]
["Irv",2377]
["Jill",1835]
["Kanya",2229]
["Piper",1573]
["Tana",1656]
["Tucker",2354]
["Yolane",1684]
["Nannette",1684]
["Adora",1684]
["Grand Total",23460]

{"sheet":"Sample Data","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA Code to Create Pivot Table with Dynamic Range"]
[]
[null,"First Name","Last Name","Email","Gross Pay"]
[null,"Irv","Lewing","ilewing0@cnn.com",2377]
[null,"Florance","Pavek","fpavek1@bbc.co.uk",1689]
[null,"Piper","Sleep","psleep2@yale.edu",1573]
[null,"Jill","Odda","jodda3@ucoz.ru",1835]
[null,"Hollis","Sawood","hsawood4@earthlink.net",2431]
[null,"Kanya","Sokill","ksokill5@squidoo.com",2229]
[null,"Yolane","Lansdown","ylansdown6@meetup.com",1684]
[null,"Tucker","Rouf","trouf7@toplist.cz",2354]
[null,"Ilene","Pineaux","ipineaux8@opera.com",2264]
[null,"Tana","Santoro","tsantoro9@xinhuanet.com",1656]
[null,"Nannette","Tabram","ntabrama@freewebs.com",1684]
[null,"Adora","Gunthorpe","agunthorpeb@gmpg.org",1684]

{"sheet":"Pivot","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Sum of Gross Pay"]
["Florance",1689]
["Hollis",2431]
["Ilene",2264]
["Irv",2377]
["Jill",1835]
["Kanya",2229]
["Piper",1573]
["Tana",1656]
["Tucker",2354]
["Yolane",1684]
["Grand Total",20092]

{"sheet":"Data","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"How to Automatically Create Pivot Table in Excel"]
[]
[null,"First Name","Last Name","Email","Gross Pay"]
[null,"Irv","Lewing","ilewing0@cnn.com",2377]
[null,"Florance","Pavek","fpavek1@bbc.co.uk",1689]
[null,"Piper","Sleep","psleep2@yale.edu",1573]
[null,"Jill","Odda","jodda3@ucoz.ru",1835]
[null,"Hollis","Sawood","hsawood4@earthlink.net",2431]
[null,"Kanya","Sokill","ksokill5@squidoo.com",2229]
[null,"Yolane","Lansdown","ylansdown6@meetup.com",1684]
[null,"Tucker","Rouf","trouf7@toplist.cz",2354]
[null,"Ilene","Pineaux","ipineaux8@opera.com",2264]
[null,"Tana","Santoro","tsantoro9@xinhuanet.com",1656]