{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Pivot table"],"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":"Data","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Client","Amount"]
[null,"2011-01-01","Client D",550]
[null,"2011-01-04","Client A",380]
[null,"2011-01-07","Client C",130]
[null,"2011-01-09","Client D",130]
[null,"2011-01-14","Client D",660]
[null,"2011-01-15","Client A",180]
[null,"2011-01-20","Client C",200]
[null,"2011-01-21","Client B",380]
[null,"2011-01-24","Client D",810]
[null,"2011-01-25","Client A",590]
[null,"2011-01-26","Client A",770]
[null,"2011-01-30","Client B",830]
[null,"2011-02-02","Client A",290]
[null,"2011-02-02","Client D",220]
[null,"2011-02-05","Client A",880]
[null,"2011-02-05","Client B",380]
[null,"2011-02-10","Client A",140]
[null,"2011-02-15","Client D",150]
[null,"2011-02-20","Client C",180]
[null,"2011-02-21","Client A",920]
[null,"2011-02-24","Client A",890]
[null,"2011-02-26","Client B",830]
[null,"2011-03-02","Client A",520]
[null,"2011-01-06","Client A",2300]

{"sheet":"Pivot table","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Client","Client A"]
[]
["Sum of Amount"]
["Date","Total"]
["2011-01-04",380]
["2011-01-15",180]
["2011-01-25",590]
["2011-01-26",770]
["2011-01-06",2300]
["Grand Total",4220]