{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Identification Mail","Date Réception","Date transfert","OBJET","Référence","Date naissance","NOM","Pseudo","Qual","LIBELLE CATEGORIE","Numéro commande"]
[1231235,"2021-10-23"," ","Test",111111111111111,"2000-08-12","TEST","P1","E","  "]
[1231235,"2021-10-23"," ","Test",111111111111111,"2004-06-21","TEST","P22","E","  "]
[1231235,"2021-10-23"," ","Test",111111111111111,"1998-03-25","TEST","P23","E","  "]
[1231235,"2021-10-23"," ","Test",111111111111111,"2003-04-14","TEST","P24","E","  ",null,"Ctrl + t pour lancer la macro qui transpose en Feuil 2"]
[1231235,"2021-10-23"," ","Test",111111111111111,"1984-09-29","TEST","P25","C","  "]
[1231235,"2021-10-23"," ","Test",111111111111111,"1980-04-01","TEST","SANDRI ","A ","  ",8546222021,"Cliquer droit sur nom onglet puis Visualiser le code pour ouvrir editeur VBA puis aller dans Module 1 pour voir la macro"]
[1231236,"2021-10-29"," ","Test",111111111111122,"1972-08-18","TOTO","TR2","CO","  "]
[1231236,"2021-10-29"," ","Test",111111111111122,"1995-05-25","TOTO","TR65","E","  "]
[1231236,"2021-10-29"," ","Test",111111111111122,"1950-04-02","TOTO","TR55","AA","  "]
[1231236,"2021-10-29"," ","Test",111111111111122,"1997-01-02","TRI","TR12","E","  "]
[1231236,"2021-10-29"," ","Test",111111111111122,"1971-07-25","RETST","TR365","A ","  ",8546222022]
[1231237,"2021-10-30"," ","Test",111111111111123,"1984-09-02","TOTO","SD54","A ","  ",8546222023]
[1231238,"2021-10-31",null,"Test",111111111111124,"2006-07-05","GLOPD","HG65","E"]
[1231238,"2021-10-31",null,"Test",111111111111124,"2010-09-09","GLOPD","GH9","E"]
[1231238,"2021-10-31",null,"Test",111111111111124,"1998-04-25","GLOPD","SDSD2","C"]
[1231238,"2021-10-31"," ","Test",111111111111124,"1988-10-15","GLOPD","GF8","A ","  ",8546222024]
[]
[]
[]
["Pour le regroupement, la condition est référence unique en colonne E"]
[]
["Le regroupement se fait sur la ligne ou figure le numéro de commande (colonne K)"]

{"sheet":"Feuil2","index":1,"n_rows":1,"n_cols":51,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Identification Mail","Date Réception","Date transfert","OBJET","Référence","Date naissance","NOM","Pseudo","Qual","LIBELLE CATEGORIE","Numéro commande","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual","Date naissance","NOM","Pseudo","Qual"]