{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Feuil1","Feuil2","Feuil3","Feuil4","Feuil5","Feuil6"],"not_rendered":{"images":3,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":23,"n_cols":15,"rows_kept":23}
["Description","QTE/Unité","Taux","Total"]
["Travaux A ",22,{"v":80,"d":"80.00"},{"$f":"B2*C2","v":1760}]
["Travaux B",10,{"v":50,"d":"50.00"},{"$f":"B3*C3","v":500}]
["Travaux C",5,{"v":25,"d":"25.00"},125]
["Voici le format de la colonne B",{"$nulls":7},"Private Sub UserForm_Initialize()"]
[{"$nulls":8},"Dim i As Integer"]
[{"$nulls":8},"    Dim c"]
[{"$nulls":8},"    Dim f As Worksheet"]
[{"$nulls":8},"    With UserForm1"]
[{"$nulls":8},"   Me.ListBox1.Clear"]
[{"$nulls":8},".ListBox1.ColumnCount = 4"]
[{"$nulls":8},".ListBox1.ColumnWidths = \"80;50;50;50\""]
[{"$nulls":8},".ListBox1.MultiSelect = fmMultiSelectMulti"]
[{"$nulls":8},"Set f = Sheets(\"Feuil1\")"]
[{"$nulls":8},"For Each c In f.Range(\"A1:A\" & f.[a650].End(xlUp).Row)"]
[{"$nulls":8},"i = i + 1"]
[{"$nulls":8},".ListBox1.AddItem c",null,"Colonne A"]
[{"$nulls":8},".ListBox1.List(i - 1, 1) = c.Offset(0, 1).Value ' comment formatter General heures"]
[{"$nulls":8},".ListBox1.List(i - 1, 2) = Format(c.Offset(0, 2).Value, \"0.00\") 'format nombre",{"$nulls":5},"colonne C"]
[{"$nulls":8},".ListBox1.List(i - 1, 3) = Format(c.Offset(0, 3).Value, \"0\") 'format standard",{"$nulls":5},"Colonne D"]
[{"$nulls":8},"Next"]
[{"$nulls":8},"End With"]
[{"$nulls":8},"End Sub"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Feuil4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Feuil5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Feuil6","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}