{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Pieces","Sheet1","Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":1,"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":"Pieces","index":0,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
[]
[]
[]
[null,"ID","Pièce","Article","Designation","Qte","Prix  HT","Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne29","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43","Colonne44","Colonne45","Colonne46","Colonne47","Colonne48","Colonne49","Colonne50"]
[null,{"$f":"ROW(B7)-6","v":1},"TR-0000001","F002-001","Chateau Mouton Rothschild",1,0,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
[null,{"$f":"ROW(B8)-6","v":2},"TR-0000001","F002-002","Mouton Cadet",2,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,{"$f":"ROW(B9)-6","v":3},"TR-0000002","F002-003","Veuve Clicquot",4,0]
[null,{"$f":"ROW(B10)-6","v":4},"TR-0000002","F002-001","Chateau Mouton Rothschild",6,0]
[null,{"$f":"ROW(B11)-6","v":5},"TR-0000002","F002-004","Moet",7,0]
[null,{"$f":"ROW(B12)-6","v":6},"TR-0000003","F002-006","Chateau Mouton Rothschild",9,0]

{"sheet":"Sheet1","index":1,"n_rows":6,"n_cols":57,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"ID","Pièce","Article","Designation","Qte","Prix  HT","Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne29","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43","Colonne44","Colonne45","Colonne46","Colonne47","Colonne48","Colonne49","Colonne50"]

{"sheet":"Feuil1","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"JSCH19 - 1 sept. 2022 à 07:06"]
[null,null,"Bonsoir le forum,"]
[null,null,"je cherche a copier des lignes specifique d'un tableau vers un autre,"]
[null,null,"pour illustrer ma demande:"]
[null,null,"disons que j'ai deux tableaux,Tableau1 et Tableau2 composes de 6 colonnes (\"B:G\")"]
[null,null,"j'aimerais copier a partir des colonnes (\"D:G\") du tableau1 vers les colonnes respectives du Tableau2"]
[null,null,"voila mon code et un exemple du fichier que j'utilise."]

{"sheet":"Feuil2","index":3,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,1,2,3,6,5,6]