{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"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":"Sheet1","index":0,"n_rows":120,"n_cols":4,"rows_kept":120,"cut":false,"hidden":false,"merged":[[16,3,18,8]]}
["An example on how to manipulate an Excel sheet by using FlexCel"]
["The first cell where we will fill the data is in the named range \"Data\" (A20)"]
[]
["Country","Quantity"]
["USA",{"$f":"SUMIF(A20:B120,\"USA\", B20:B120)","v":0}]
["Canada",{"$f":"SUMIF(A20:B120,\"Canada\", B20:B120)","v":0}]
["Spain",{"$f":"SUMIF(A20:B120,\"Spain\", B20:B120)","v":0}]
["France",{"$f":"SUMIF(A20:B120,\"France\", B20:B120)","v":0}]
["United Kingdom",{"$f":"SUMIF(A20:B120,\"United Kingdom\", B20:B120)","v":0}]
["Australia",{"$f":"SUMIF(A20:B120,\"Australia\", B20:B120)","v":0}]
["Brazil",{"$f":"SUMIF(A20:B120,\"Brazil\", B20:B120)","v":0}]
["no",{"$f":"SUMIF(A20:B120,\"Unknown\", B20:B120)","v":0}]
[]
[]
[]
[]
[null,null,null,"Note: This button has its properties set to \"Don't move or resize with cells\" so it does not move when inserting rows to create the chart"]
[]
["Country","Quantity"]
["USA",868]
["USA",964]
["Canada",560]
["Canada",209]
["Canada",232]
["Spain",228]
["France",176]
["France",748]
["United Kingdom",327]
["Australia",431]
["Australia",445]
["Australia",168]
["Brazil",445]
["Brazil",410]
["Brazil",452]
["Brazil",190]
["Brazil",345]
["Brazil",778]
["no",861]
["no",119]
["USA",552]
["Canada",496]
["Canada",124]
["Canada",73]
["Canada",980]
["Canada",253]
["Canada",0]
["Spain",15]
["Spain",852]
["France",657]
["France",392]
["France",607]
["France",942]
["United Kingdom",243]
["United Kingdom",492]
["Australia",869]
["Brazil",130]
["Brazil",292]
["Brazil",241]
["no",655]
["no",268]
["USA",459]
["USA",99]
["USA",940]
["USA",353]
["USA",221]
["Canada",130]
["Canada",920]
["Canada",20]
["Spain",126]
["Spain",400]
["Spain",923]
["Spain",346]
["Spain",870]
["Spain",681]
["France",134]
["United Kingdom",965]
["United Kingdom",169]
["United Kingdom",479]
["United Kingdom",134]
["Australia",492]
["Australia",459]
["Australia",363]
["Australia",245]
["Australia",268]
["Brazil",400]
["no",613]
["no",699]
["USA",409]
["USA",190]
["Canada",180]
["Canada",605]
["Canada",175]
["Spain",705]
["France",956]
["France",741]
["France",643]
["United Kingdom",433]
["United Kingdom",361]
["United Kingdom",154]
["United Kingdom",703]
["United Kingdom",236]
["United Kingdom",234]
["United Kingdom",569]
["United Kingdom",355]
["United Kingdom",916]
["Australia",47]
["Australia",615]
["Brazil",328]
["Brazil",593]
["Brazil",425]
["Brazil",861]
["no",6]
["USA",907]
["Canada",977]
["Canada",671]
["Canada",670]
["Canada",14]
["Canada",449]
["Canada",858]
["Spain",48]

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

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