{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"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":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,6,1,14],[2,6,8,17]]}
[null,null,null,null,null,null,"Situation: après une macro, l'acheteur obtient le tableau suivant. Il effectue ensuite certains  filtres. Par exemple pour obtenir les lignes d'un seul fournisseur, et seulement certains PO."]
[]
[null,null,null,null,null,null,"Objectif: lorsque l'acheteur a fait ses filtres, il clique sur le bouton mail.                                                                                                                                                                                    - L'objet du mail peut être \"relance\"relance par exempe                                                                                                                                                                                                                    - Le corps du mail devra être le suivant: \"Hello Nom du contact en feuil 2 qui correspond au contact du fournisseur filtré(sil'acheteur a filtré les lignes pour le fournisseur A, il faut que le nom soit : \"jéjé\"). Here after are the lines you need to send us:                                                                                                                                                                                                                                              Et là j'aimerais le tableausuivant, avec la mise en forme:                                                                                                                                                                                                                               seulement les lignes visibles après filtre de l'acheteur, seulement les colonnes \"Part number, PO number, Delivery  Date, Quantity\"                                                                                                                                                                                                                                           Thank you for your cooperation....."]
[]
[]
[]
[]
[]
[]
["Buyer","N° de commande\nClient","Part Number","Description","Supplier","PO\nNumber","Delivery Date\n(DD/MM/YY)","Quantity","Quantity\nReceived","Statut de la ligne","Transport","N° AR Client\nDate accusée","Infos","Relance\nà\nFaire","prix unitaire","currency","date création du PO","N° AR client","Date de Livraison\nClient","traitement de la commande","Date réelle","Statut","nb de jour","Delivery \nDate\nInitiale","Retard\nDate Initiale","Retard\nDate Initiale","Nombre de jours avant livraison"]
["yaya",null,"1",null,"A","20","2012-12-27",80,0,null,null,234,null,8,null,"USD","2012-11-07",null," ","En cours","2012-12-27",null," ","15/12/12",-12,-12,-147]
["yaya",null,"2",null,"A","21","2012-12-31",47,0,null,null,235,null,8,null,"USD","2012-11-07",null," ","En cours","2012-12-31",null," ","15/12/12",-16,-16,-143]
["yaya",null,"3",null,"A","22","2013-04-10",1000,0,null,12,236,null,8,null,"USD","2013-02-18",null,"8/04/2013","AR envoyé","2013-04-22",null,-14,"27/03/13  ",-14,-14,-43]
["yaya",null,"4",null,"A","23","2013-04-10",800,0,null,12,237,null,8,null,"USD","2013-02-18",null,"8/04/2013","AR envoyé","2013-04-22",null,-14,"27/03/13  ",-14,-14,-43]
["yaya",null,"5",null,"A","24","2013-04-22",1500,0,null,12,238,null,8,null,"USD","2013-03-11",null,"26/04/2013","AR envoyé","2013-05-04",null,-8,"22/04/13 i",{"$error":"#VALUE!"}," ",-31]
["yaya",null,"6",null,"B","25","2013-04-10",2400,0,null,12,239,null,8,null,"USD","2013-02-18",null,"8/04/2013","AR envoyé","2013-04-22",null,-14,"27/03/13  ",-14,-14,-43]
["yaya",null,"7",null,"B","26","2013-05-24",5,0,null,5,240,null,2,null,"USD","2013-04-26",null,"30/05/2013","AR envoyé","2013-05-29",null,1,"24/05/13  ",0,0,1]
["yaya",null,"8",null,"B","27","2013-05-24",5,0,null,5,241,null,2,null,"USD","2013-04-26",null,"30/05/2013","AR envoyé","2013-05-29",null,1,"24/05/13",0,0,1]
["yaya",null,"9",null,"B","28","2013-05-24",5,0,null,5,242,null,2,null,"USD","2013-04-26",null,"30/05/2013","AR envoyé","2013-05-29",null,1,"24/05/1",-4383,-4383,1]
["yaya",null,"10",null,"C","29","2012-04-07",2,1,null,5,243,null,8,null,"USD","2012-03-14",null,"06/04/2012","AR envoyé","2012-04-12",null,-6,"27/03/12",-11,-11,-411]
["yaya",null,"11",null,"C","30","2012-04-07",2,1,null,5,244,null,8,null,"USD","2012-03-14",null,"06/04/2012","AR envoyé","2012-04-12",null,-6,"27/03/12",-11,-11,-411]

{"sheet":"Feuil2","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["fournisseur","contact","adresse mail"]
["A","jéjé","a@a.com"]
["B","lulu","b@b.com"]
["C","toto","c@c.com"]

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