{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Commande","Bordereau"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Commande","index":0,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Commande","Code client","Nom Client","produit","code produit","caracteristique","poids","destination","Var 1","Var 2","Var 3","Var 4","Var 5","Var 6","Var 7","Var 8","Var 9","Var 10","Var 11","Var 11","Var 12"]
[112,2150,"HD Print","Papier","P123","A4",1000,"Paris"]
[112,2150,"HD Print","stylo","A1234","Boite x10",250,"Paris"]
[112,2150,"HD Print","eponge","E12",4,100,"Paris"]
[112,2150,"HD Print","stylo","S14",4,100,"Paris"]
[112,2150,"HD Print","ampoule","a27",4,135,"Paris"]
[112,2150,"HD Print","Etiquette","ET12",100,400,"Pars"]
[112,2150,"HD Print","Cartouche Epson","M2000",1,800]
[112,2150,"HD Print","Cartouche Canon","KPS250",1,450]
[112,2150,"HD Print"]
[112,2150,"HD Print"]
[112,2150,"HD Print"]
[112,2150,"HD Print"]
[112,2150,"HD Print"]
[2156,58,"Orange","Object0","Objet1","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object1","Objet2","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object2","Objet3","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object3","Objet4","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object4","Objet5","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object5","Objet6","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object6","Objet7","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object7","Objet8","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]
[2156,58,"Orange","Object8","Objet9","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12","Objet13","Objet14"]

{"sheet":"Bordereau","index":1,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,2,8],[3,0,3,2],[4,0,4,2],[5,0,5,2]]}
["Commande",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(Bordereau!A2,Commande!A2:A23,0)","v":14}]
[2156,null,"Je veux saisir le code commande en B2 et que cette seule saisie compléte les données à partir de B7..exemple 112"]
[]
["Récapitulatif commande"]
["Nbre de pièces",null,null,null,"Quelles données utilises-tu pour dénombre le nombre de pièces?"]
["Code Client",null,null,{"$f":"INDEX(Code_Client,MATCH(Bordereau!A2,Commande,0))","v":58}]
["Elements commande"]
["produit","code produit","caracteristique","poids","destination","Var 1","Var 2","Var 3","Var 4","Var 5","Var 6","Var 7","Var 8","Var 9"]
[null,"Objet1","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet2","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet3","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet4","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet5","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet6","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet7","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet8","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]
[null,"Objet9","Objet1","Objet2","Objet3","Objet4","Objet5","Objet6","Objet7","Objet8","Objet9","Objet10","Objet11","Objet12"]