{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PivotSheet","DataSheet"],"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":"PivotSheet","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Days Present","Sum of Days Absent","Sum of Bonus"]
["Charlotte White",20,0,100]
["IT",20,0,100]
["Los Angeles",20,0,100]
["Emma Lee",20,5,100]
["Finance",20,5,100]
["London",20,5,100]
["Ethan Young",22,4,110]
["HR",22,4,110]
["Vancouver",22,4,110]
["Jack Anderson",18,0,90]
["Marketing",18,0,90]
["Vancouver",18,0,90]
["John Smith",41,8,205]
["HR",41,8,205]
["Chicago",20,5,100]
["Brisbane",21,3,105]
["Liam Thompson",20,3,100]
["IT",20,3,100]
["London",20,3,100]
["Lucas King",18,5,90]
["Finance",18,5,90]
["Wellington",18,5,90]
["Michael Brown",18,2,90]
["Marketing",18,2,90]
["New York",18,2,90]
["Oliver Wilson",18,5,90]
["Finance",18,5,90]
["Auckland",18,5,90]
["Ruby Scott",19,1,95]
["HR",19,1,95]
["Auckland",19,1,95]
["Sophie Walker",18,1,90]
["Finance",18,1,90]
["Christchurch",18,1,90]
["Grand Total",232,34,1160]

{"sheet":"DataSheet","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Employee","Department","Days Present","Days Absent","City"]
["Michael Brown","Marketing",18,2,"New York"]
["Ethan Young","HR",22,4,"Vancouver"]
["Sophie Walker","Finance",18,1,"Christchurch"]
["Ruby Scott","HR",19,1,"Auckland"]
["John Smith","HR",20,5,"Chicago"]
["Jack Anderson","Marketing",18,0,"Vancouver"]
["Lucas King","Finance",18,5,"Wellington"]
["Charlotte White","IT",20,0,"Los Angeles"]
["Emma Lee","Finance",20,5,"London"]
["John Smith","HR",21,3,"Brisbane"]
["Oliver Wilson","Finance",18,5,"Auckland"]
["Liam Thompson","IT",20,3,"London"]