{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Avant","Feuil1"],"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":"Avant","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["AVANT",10,20,30,40]
["Pierre","G01","G02","G03","G04"]
["Paul","G02","G03","G01","G01"]
["Jacques","G03","G01","G04","G02"]
["Marie","G04","G04","G02","G03"]
[]
[]
["APRES","G01","G02","G03","G04"]
[10,{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(B$10,Avant!$B$4:$B$7,0),1)","v":"Pierre"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(C$10,Avant!$B$4:$B$7,0),1)","v":"Paul"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(D$10,Avant!$B$4:$B$7,0),1)","v":"Jacques"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(E$10,Avant!$B$4:$B$7,0),1)","v":"Marie"}]
[20,{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(B$10,Avant!$C$4:$C$7,0),1)","v":"Jacques"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(C$10,Avant!$C$4:$C$7,0),1)","v":"Pierre"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(D$10,Avant!$C$4:$C$7,0),1)","v":"Paul"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(E$10,Avant!$C$4:$C$7,0),1)","v":"Marie"}]
[30,{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(B$10,Avant!$D$4:$D$7,0),1)","v":"Paul"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(C$10,Avant!$D$4:$D$7,0),1)","v":"Marie"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(D$10,Avant!$D$4:$D$7,0),1)","v":"Pierre"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(E$10,Avant!$D$4:$D$7,0),1)","v":"Jacques"}]
[40,{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(B$10,Avant!$E$4:$E$7,0),1)","v":"Paul"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(C$10,Avant!$E$4:$E$7,0),1)","v":"Jacques"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(D$10,Avant!$E$4:$E$7,0),1)","v":"Marie"},{"$f":"INDEX(Avant!$A$4:$A$7,MATCH(E$10,Avant!$E$4:$E$7,0),1)","v":"Pierre"}]
[]
[]
[]
["Comment par vba (tableau) ou dictionnaire arrriver à faire le tableau APRES en partant du tableau AVANT ?"]

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