{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Feuil1","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Marc aime le coca",{"$f":"IF(SUMPRODUCT((COUNTIF(A1,\"*\"&$D$2:$D$3&\"*\"))*1),$D$1,IF(SUMPRODUCT((COUNTIF(A1,\"*\"&$E$2:$E$4&\"*\"))*1),$E$1,IF(SUMPRODUCT((COUNTIF(A1,\"*\"&$F$2:$F$3&\"*\"))*1),$F$1,\"autres\")))","v":"Sodas"},null,"Alcool","Sodas","fruits"]
["Georges est plutôt oasis",{"$f":"IF(SUMPRODUCT((COUNTIF(A2,\"*\"&$D$2:$D$3&\"*\"))*1),$D$1,IF(SUMPRODUCT((COUNTIF(A2,\"*\"&$E$2:$E$4&\"*\"))*1),$E$1,IF(SUMPRODUCT((COUNTIF(A2,\"*\"&$F$2:$F$3&\"*\"))*1),$F$1,\"autres\")))","v":"Sodas"},null,"vodka","coca","prune"]
["Le chien est fan de heineken","autres",null,"heinekein","oasis","orange"]
["Le Coca est très réputé","Sodas",null,null,"ice-tea","peche"]
["J'aime les oranges","fruits"]
["une tranche de pain","autres"]
["Les peches sont juteuses","autres"]
["La vodka c'est top","Alcool"]
["Moi je fais rien de tout ca","autres"]
["vodka","Alcool"]
["coca","Sodas"]
["peche","autres"]
["orange","fruits"]
["prune","fruits"]
["vodka","Alcool"]
[]
["Solution A"]
["Pas de contrainte de limite dans mon tableau en revanche si je n'ai pas la notion de \"Contient\" comme dans la formule colonne B qui m'est indispensable"]
[]
["Solution B"]
["imaginer le principe avec 5 colonnes et autant de mots clés que souhaités dans mon tableau et la formule colonne B révèle sa contrainte de limite"]

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

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