{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Data","Parameter","Cible List"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
["Référence","Libellé","Qté","Prix","Valeur"]
["A001","Bouteille",15,{"v":17,"d":"17.00"},{"$f":"C2*D2","v":{"v":255,"d":"255.00"}}]
["A002","Verre",50,{"v":4.5,"d":"4.50"},{"$f":"C3*D3","v":{"v":225,"d":"225.00"}}]
["T001","Nappe",4,{"v":55,"d":"55.00"},{"$f":"C4*D4","v":{"v":220,"d":"220.00"}}]
["T002","Serviette",10,{"v":5,"d":"5.00"},{"$f":"C5*D5","v":{"v":50,"d":"50.00"}}]
["A003","Cuillère",30,{"v":2,"d":"2.00"},{"$f":"C6*D6","v":{"v":60,"d":"60.00"}}]
["Total",{"$f":"\"Nbre d'articles :  \" & SUBTOTAL(103,T_Source[Libellé])","v":"Nbre d'articles :  5"},{"$f":"SUBTOTAL(109,T_Source[Qté])","v":109},{"$f":"SUBTOTAL(101,T_Source[Prix])","v":{"v":16.7,"d":"16.70"}},{"$f":"SUBTOTAL(109,T_Source[Valeur])","v":{"v":810,"d":"810.00"}}]

{"sheet":"Parameter","index":1,"n_rows":2,"n_cols":3,"rows_kept":2}
["Référence",null,"Nbre à exporter"]
["a*",null,{"$f":"DCOUNTA( T_Source[ [#Headers], [#Data] ], T_Source[ [#Headers], [Référence] ], areaCriteria )","v":3}]

{"sheet":"Cible List","index":2,"n_rows":5,"n_cols":3,"rows_kept":5}
["Référence","Libellé","Valeur"]
["A001","Bouteille",{"v":255,"d":"255.00"}]
["A002","Verre",{"v":225,"d":"225.00"}]
["A003","Cuillère",{"v":60,"d":"60.00"}]
[{"$f":"\"Nbre \" & SUBTOTAL(103,T_Cible[Référence])","v":"Nbre 3"},null,{"$f":"SUBTOTAL(109,T_Cible[Valeur])","v":{"v":540,"d":"540.00"}}]