{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","solution 1 ","solution 2"],"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":43,"n_cols":5,"rows_kept":43}
{"$rows_empty":16}
[null,"TOTAUX coupures\nRETOURS"]
[null,"TOTAL par région",null,null,165]
[{"$nulls":4},18]
[null,"Retours","code","DATE","MODE"]
[]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon fenouillet"]
[{"$nulls":3},"lun-15-sept","Wagon fenouillet"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[{"$nulls":4},"route"]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]

{"sheet":"solution 1 ","index":1,"n_rows":43,"n_cols":5,"rows_kept":43}
{"$rows_empty":8}
[null,"Solution 1 : insérer les lignes ou  faire sauter une ligne lorsque la valeur est différente de la précédente sur D22:D43"]
{"$rows_empty":7}
[null,"TOTAUX coupures\nRETOURS"]
[null,"TOTAL par région",null,null,165]
[{"$nulls":4},18]
[null,"Retours","code","DATE","MODE"]
[]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon fenouillet"]
[{"$nulls":3},"lun-15-sept","Wagon fenouillet"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[{"$nulls":4},"route"]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]

{"sheet":"solution 2","index":2,"n_rows":51,"n_cols":14,"rows_kept":51}
{"$rows_empty":11}
[null,"Solution 2  : je fais en sorte d'espacer mon remplissage automatique et la macro supprime la ligne qui sépare deux cases de la colone E identiques "]
[]
[]
[]
[]
[null,"TOTAUX coupures\nRETOURS"]
[null,"TOTAL par région",null,null,165,{"$nulls":5},"TOTAUX coupures\nRETOURS"]
[{"$nulls":4},18,{"$nulls":5},"TOTAL par région",null,null,165]
[null,"Retours","code","DATE","MODE",{"$nulls":8},18]
[{"$nulls":10},"Retours","code","DATE","MODE"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":12},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas",{"$nulls":7},"lun-15-sept","Wagon Miramas"]
[{"$nulls":12},"lun-15-sept","Wagon Miramas"]
[{"$nulls":3},"lun-15-sept","Wagon Miramas"]
[{"$nulls":12},"lun-15-sept","Wagon fenouillet"]
[{"$nulls":3},"lun-15-sept","Wagon fenouillet",{"$nulls":7},"lun-15-sept","Wagon fenouillet"]
[]
[{"$nulls":3},"lun-15-sept","Wagon fenouillet",{"$nulls":7},"lun-15-sept","Wagon Rennes"]
[{"$nulls":12},"lun-15-sept","Wagon Rennes"]
[{"$nulls":3},"lun-15-sept","Wagon Rennes",{"$nulls":7},"lun-15-sept","Wagon Rennes"]
[]
[{"$nulls":3},"lun-15-sept","Wagon Rennes",{"$nulls":8},"route"]
[]
[{"$nulls":3},"lun-15-sept","Wagon Rennes"]
[]
[{"$nulls":4},"route"]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]
[null,"  "]