{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","InputData","Sheet3"],"not_rendered":{"charts":0,"images":7,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Create Pivot Table \n& \nPivot Fields"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"InputData","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Item","Date","Qty","Price","Location","Zone",null,"Zone","(All)"]
["Apple","2018-01-29",450,15,"Hyderabad","North"]
["Banana","2018-01-30",365,24,"Chennai","East",null,"Sum of Qty","Column Labels"]
["Orange","2017-01-31",157,36,"Banglore","South",null,"Row Labels","Apple","Banana","Grapes","Orange","Grand Total"]
["Grapes","2018-02-01",852,14,"Chennai","West",null,"Banglore",535,null,356,157,1048]
["Apple","2018-02-02",250,15,"Chennai","North",null,"Chennai",250,1023,852,452,2577]
["Banana","2018-02-03",236,47,"Hyderabad","East",null,"Hyderabad",628,236,null,874,1738]
["Orange","2018-02-04",452,22,"Chennai","South",null,"Pune",478,675,362,452,1967]
["Grapes","2018-02-05",362,35,"Pune","West",null,"Grand Total",1891,1934,1570,1935,7330]
["Apple","2018-02-06",535,44,"Banglore","North"]
["Banana","2018-02-07",675,36,"Pune","East"]
["Orange","2017-02-08",874,27,"Hyderabad","South"]
["Grapes","2018-02-09",356,28,"Banglore","West"]
["Apple","2017-02-10",478,29,"Pune","North"]
["Banana","2018-02-11",658,44,"Chennai","East"]
["Apple","2017-02-12",178,44,"Hyderabad","North"]
["Orange","2018-02-04",452,22,"Pune","South"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}