{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BILAN PRODUIT A","AGENCE LYON","AGENCE MARSEILLE","AGENCE PARIS","query+tcd"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":"BILAN PRODUIT A","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["BILAN VENTE PRODUIT A",null,null,null,null,"LISTE DES AGENCES"]
[null,null,null,null,null,{"$f":"Nom_Feuille","v":"BILAN PRODUIT A"}]
["Référence","Date vente","Agence",null,null,"AGENCE LYON"]
[null,null,null,null,null,"AGENCE MARSEILLE"]
[null,null,null,null,null,"AGENCE PARIS"]
[null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"}]
[]
[]
[]
[]
[]
["Le but est d'aller chercher dans tous les onglets listés dans la Liste des Agences, les éléments relatifs aux ventes de Produit A. Il peut y avoir plusieurs occurrences dans chaque onglets."]

{"sheet":"AGENCE LYON","index":1,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Type de produit","Référence","Date de vente","agence"]
["Produit A","A2356","2019-02-01",{"$f":"agence","v":"LYON"},null,null,{"$f":"CELL( \"nomfichier\",INDIRECT(\"a1\"))","v":"D:\\Téléchargements\\.Fichiers Excel\\[EXEMPLE.xlsm]AGENCE LYON"}]
["Produit A","E6743","2019-06-05",{"$f":"agence","v":"LYON"}]
["Produit A","E6744","2019-05-23",{"$f":"agence","v":"LYON"}]
["Produit B","E5985","2019-03-12",{"$f":"agence","v":"LYON"},null,null,{"$f":"RIGHT(feuille,LEN(feuille)-(SEARCH(\"]\",feuille)+7))","v":"LYON"}]
["Produit B","J6746","2019-07-15",{"$f":"agence","v":"LYON"}]
["Produit C","E6747","2019-09-06",{"$f":"agence","v":"LYON"}]
["Produit C","T3489","2019-02-02",{"$f":"agence","v":"LYON"}]
["Produit C","U2391","2019-02-15",{"$f":"agence","v":"LYON"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"agence","v":"LYON"}]
[null,null,null,null,null,null,{"$f":"feuille","v":"D:\\Téléchargements\\.Fichiers Excel\\[EXEMPLE.xlsm]AGENCE LYON"}]
[]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(feuille,LEN(feuille)-SEARCH(\" \",feuille))","v":"Excel\\[EXEMPLE.xlsm]AGENCE LYON"}]

{"sheet":"AGENCE MARSEILLE","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Type de produit","Référence","Date de vente","agence"]
["Produit A","U7541","2019-10-13T00:08:14.699",{"$f":"agence","v":"MARSEILLE"}]
["Produit A","S3698","2019-01-08T12:11:21.521",{"$f":"agence","v":"MARSEILLE"}]
["Produit B","T3489","2019-06-23T10:28:13.581",{"$f":"agence","v":"MARSEILLE"}]
["Produit B","I7620","2019-04-26T18:55:38.414",{"$f":"agence","v":"MARSEILLE"}]
["Produit B","T2286","2019-09-26T10:33:16.669",{"$f":"agence","v":"MARSEILLE"}]
["Produit B","I7825","2019-06-28",{"$f":"agence","v":"MARSEILLE"}]
["Produit B","P1672","2019-06-29",{"$f":"agence","v":"MARSEILLE"}]
["Produit B","P1145","2019-06-30T02:44:09.679",{"$f":"agence","v":"MARSEILLE"}]
["Produit C","N7809","2019-09-18T05:33:13.638",{"$f":"agence","v":"MARSEILLE"}]
["Produit C","T5620","2019-11-29T12:06:45.149",{"$f":"agence","v":"MARSEILLE"}]

{"sheet":"AGENCE PARIS","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Type de produit","Référence","Date de vente","agence"]
["Produit A","A3244","2019-05-16T18:41:55.324",{"$f":"agence","v":"PARIS"}]
["Produit A","T7853","2019-01-18T15:40:20.791",{"$f":"agence","v":"PARIS"}]
["Produit A","G7321","2019-01-14T04:06:56.293",{"$f":"agence","v":"PARIS"}]
["Produit A","C0957","2019-11-27T00:03:40.429",{"$f":"agence","v":"PARIS"}]
["Produit B","R7519","2019-02-20T10:36:50.934",{"$f":"agence","v":"PARIS"}]
["Produit C","B3718","2019-09-02T02:13:21.638",{"$f":"agence","v":"PARIS"}]
["Produit C","C5532","2019-03-30T05:47:34.400",{"$f":"agence","v":"PARIS"}]

{"sheet":"query+tcd","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Type de produit","Référence","Date de vente","agence"]
["Produit A","S3698","2019-01-08","MARSEILLE"]
["Produit A","G7321","2019-01-14","PARIS"]
["Produit A","T7853","2019-01-18","PARIS",null,null,"Référence","agence","Date de vente"]
["Produit A","A2356","2019-02-01","LYON",null,null,"B3718","PARIS","2019-09-02"]
["Produit C","T3489","2019-02-02","LYON",null,null,"C5532","PARIS","2019-03-30"]
["Produit C","U2391","2019-02-15","LYON",null,null,"E6747","LYON","2019-09-06"]
["Produit B","R7519","2019-02-20","PARIS",null,null,"N7809","MARSEILLE","2019-09-18"]
["Produit B","E5985","2019-03-12","LYON",null,null,"T3489","LYON","2019-02-02"]
["Produit C","C5532","2019-03-30","PARIS",null,null,"T5620","MARSEILLE","2019-11-29"]
["Produit B","I7620","2019-04-26","MARSEILLE",null,null,"U2391","LYON","2019-02-15"]
["Produit A","A3244","2019-05-16","PARIS",null,null,"Total général"]
["Produit A","E6744","2019-05-23","LYON"]
["Produit A","E6743","2019-06-05","LYON"]
["Produit B","T3489","2019-06-23","MARSEILLE"]
["Produit B","I7825","2019-06-28","MARSEILLE"]
["Produit B","P1672","2019-06-29","MARSEILLE"]
["Produit B","P1145","2019-06-30","MARSEILLE"]
["Produit B","J6746","2019-07-15","LYON"]
["Produit C","B3718","2019-09-02","PARIS"]
["Produit C","E6747","2019-09-06","LYON"]
["Produit C","N7809","2019-09-18","MARSEILLE"]
["Produit B","T2286","2019-09-26","MARSEILLE"]
["Produit A","U7541","2019-10-13","MARSEILLE"]
["Produit A","C0957","2019-11-27","PARIS"]
["Produit C","T5620","2019-11-29","MARSEILLE"]