{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["NDP","Feuil2","CA"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"NDP","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Cherche98"]
[null,"Prud"]
[]
[]
[null,null,"ici feuille NDP en cellule b3:b200 une liste de nom c'est a partir de cette liste que la recherche s'effecture"]

{"sheet":"Feuil2","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Cherche98",12230,10528,11330,6,17,230,26,17,null,"la clonne b4:b200 contient le des nom et les colonne c,d,e,e,f,g,h contiennent des nombre "]
[null,"Prud",142,5,7230,23000,511,4,11,9,null,"le but etant de chercher à partir de la liste dans la feuille NDP colonne b3 pour chaque nom ,dans la feuille 2 la correspondance ,si trouver ,alors on copie les huits cellule suivante dans la feuille CA au emplacement prevue indiquer ,et on passe au nom suivant de la feuille NDP et on recommence la meme operation . pour chaque nom de la liste en feuille ndp colonne b3 un emplacement ayant le meme nom feuille Ca à etait prevue pour la copie .tous les jours je remplie la feuille 2 avec de nouvel donnee ,de faite feuille Ca je copie les nouvel donnee en dessou des precedante feuille CA "]

{"sheet":"CA","index":2,"n_rows":4,"n_cols":89,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,872,2,879],[2,881,2,888],[2,890,2,897],[2,899,2,906],[2,908,2,915],[2,818,2,825],[2,827,2,834],[2,836,2,843],[2,845,2,852],[2,854,2,861],[2,863,2,870],[2,764,2,771],[2,773,2,780],[2,782,2,789],[2,791,2,798],[2,800,2,807],[2,809,2,816],[2,710,2,717],[2,719,2,726],[2,728,2,735],[2,737,2,744],[2,746,2,753],[2,755,2,762],[2,656,2,663],[2,665,2,672],[2,674,2,681],[2,683,2,690],[2,692,2,699],[2,701,2,708],[2,602,2,609],[2,611,2,618],[2,620,2,627],[2,629,2,636],[2,638,2,645],[2,647,2,654],[2,548,2,555],[2,557,2,564],[2,566,2,573],[2,575,2,582],[2,584,2,591],[2,593,2,600],[2,494,2,501],[2,503,2,510],[2,512,2,519],[2,521,2,528],[2,530,2,537],[2,539,2,546],[2,440,2,447],[2,449,2,456],[2,458,2,465],[2,467,2,474],[2,476,2,483],[2,485,2,492],[2,386,2,393],[2,395,2,402],[2,404,2,411],[2,413,2,420],[2,422,2,429],[2,431,2,438],[2,332,2,339],[2,341,2,348],[2,350,2,357],[2,359,2,366],[2,368,2,375],[2,377,2,384],[2,278,2,285],[2,287,2,294],[2,296,2,303],[2,305,2,312],[2,314,2,321],[2,323,2,330],[2,224,2,231],[2,233,2,240],[2,242,2,249],[2,251,2,258],[2,260,2,267],[2,269,2,276],[2,170,2,177],[2,179,2,186],[2,188,2,195],[2,197,2,204],[2,206,2,213],[2,215,2,222],[2,116,2,123],[2,125,2,132],[2,134,2,141],[2,143,2,150],[2,152,2,159],[2,161,2,168],[2,62,2,69],[2,71,2,78],[2,80,2,87],[2,89,2,96],[2,98,2,105],[2,107,2,114],[2,8,2,15],[2,17,2,24],[2,26,2,33],[2,35,2,42],[2,44,2,51],[2,53,2,60]]}
[]
[]
[null,null,null,null,null,null,null,1,{"$f":"NDP!B3","v":"Cherche98"},"Cherche100",null,null,null,null,null,null,2,{"$f":"NDP!B4","v":"Prud"},null,null,null,null,null,null,null,3,{"$f":"NDP!B5","v":0},null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,12230,10528,11330,6,17,230,26,17,null,142,5,7230,23000,511,4,11,9]