{"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":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Détection",null,null,"extraction:"]
["CFERTE@gmail.fr","IN FO1","A","Paris","Paul",{"$f":"IF(COUNTIF(A2,\"*@gmail*\"),MAX($F$1:F1)+1,\"\")","v":1},null,null,{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),1),\"\")","v":"CFERTE@gmail.fr"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),2),\"\")","v":"IN FO1"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),3),\"\")","v":"A"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),4),\"\")","v":"Paris"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),5),\"\")","v":"Paul"}]
["CREFTRE@gmail.com","IN FO2","B","Marseille","Renè",{"$f":"IF(COUNTIF(A3,\"*@gmail*\"),MAX($F$1:F2)+1,\"\")","v":2},null,null,{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),1),\"\")","v":"CREFTRE@gmail.com"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),2),\"\")","v":"IN FO2"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),3),\"\")","v":"B"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),4),\"\")","v":"Marseille"},{"$f":"IF(MAX($F:$F)>=ROW()-1,INDEX($A:$E,MATCH(ROW()-1,$F:$F,0),5),\"\")","v":"Renè"}]
["FERT@orange.fr","IN FO3","C","Lyon","André",{"$f":"IF(COUNTIF(A4,\"*@gmail*\"),MAX($F$1:F3)+1,\"\")","v":""},null,null,"XXXFERTE@gmail.fr","IN FO5","E","Brunois","Marcel"]
["XSXDSRE@free.com","IN FO4","D","Birdeaux","Ewan",{"$f":"IF(COUNTIF(A5,\"*@gmail*\"),MAX($F$1:F4)+1,\"\")","v":""},null,null,"XXXREFTRE@gmail.XXXom","IN FO6","F","Toul","Patrick"]
["XXXFERTE@gmail.fr","IN FO5","E","Brunois","Marcel",{"$f":"IF(COUNTIF(A6,\"*@gmail*\"),MAX($F$1:F5)+1,\"\")","v":3},null,null,"CFZKPRTZKP@gmail.fr","IN FO9","I","Limoges","Chrystel"]
["XXXREFTRE@gmail.XXXom","IN FO6","F","Toul","Patrick",{"$f":"IF(COUNTIF(A7,\"*@gmail*\"),MAX($F$1:F6)+1,\"\")","v":4},null,null,"CRZKPFTRZKP@gmail.com","IN FO10","J","Brest","Monique"]
["FERT@orange.fr","IN FO7","G","Vezoul","Eric",{"$f":"IF(COUNTIF(A8,\"*@gmail*\"),MAX($F$1:F7)+1,\"\")","v":""},null,null,"CURGERTE@gmail.URGr","IN FO13","M","Toulouse","André"]
["XSXDSRE@free.XXXom","IN FO8","H","Vierzon","Corinne",{"$f":"IF(COUNTIF(A9,\"*@gmail*\"),MAX($F$1:F8)+1,\"\")","v":""},null,null,"CREURGTRE@gmail.com","IN FO14","N","Perpignan","Anne-Marie"]
["CFZKPRTZKP@gmail.fr","IN FO9","I","Limoges","Chrystel",{"$f":"IF(COUNTIF(A10,\"*@gmail*\"),MAX($F$1:F9)+1,\"\")","v":5},null,null,"","","","",""]
["CRZKPFTRZKP@gmail.com","IN FO10","J","Brest","Monique",{"$f":"IF(COUNTIF(A11,\"*@gmail*\"),MAX($F$1:F10)+1,\"\")","v":6},null,null,"","","","",""]
["FZKPRT@orangZKP.fr","IN FO11","K","Nantes","Léa",{"$f":"IF(COUNTIF(A12,\"*@gmail*\"),MAX($F$1:F11)+1,\"\")","v":""},null,null,"","","","",""]
["XSXDSRZKP@frZKPZKP.com","IN FO12","L","Montpellier","Lucas",{"$f":"IF(COUNTIF(A13,\"*@gmail*\"),MAX($F$1:F12)+1,\"\")","v":""},null,null,"","","","",""]
["CURGERTE@gmail.URGr","IN FO13","M","Toulouse","André",{"$f":"IF(COUNTIF(A14,\"*@gmail*\"),MAX($F$1:F13)+1,\"\")","v":7},null,null,"","","","",""]
["CREURGTRE@gmail.com","IN FO14","N","Perpignan","Anne-Marie",{"$f":"IF(COUNTIF(A15,\"*@gmail*\"),MAX($F$1:F14)+1,\"\")","v":8},null,null,"","","","",""]
["URGERT@orange.URGr","IN FO15","O","Pau","Madeleine",{"$f":"IF(COUNTIF(A16,\"*@gmail*\"),MAX($F$1:F15)+1,\"\")","v":""},null,null,"","","","",""]
["XSXDSRE@URGree.com","IN FO16","P","Bourg-en -Bresse","Pierrette",{"$f":"IF(COUNTIF(A17,\"*@gmail*\"),MAX($F$1:F16)+1,\"\")","v":""},null,null,"","","","",""]
[null,null,null,null,null,null,null,null,"","","","",""]

{"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":[]}