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
| Numero_colonne = 1
saut = txtline.Text - 1
sh.Cells(1, Numero_colonne).Value = "n°card"
sh.Cells(1, Numero_colonne).Font.Bold = True
sh.Cells(1, Numero_colonne).Borders.Weight = Excel.XlBorderWeight.xlMedium
sh.Cells(1, Numero_colonne).HorizontalAlignment = Excel.xlHAlignCenter
sh.Cells(1, Numero_colonne + 1).Value = "n°prog"
sh.Cells(1, Numero_colonne + 1).Font.Bold = True
sh.Cells(1, Numero_colonne + 1).Borders.Weight = Excel.XlBorderWeight.xlMedium
sh.Cells(1, Numero_colonne + 1).HorizontalAlignment = Excel.xlHAlignCenter
For o = 0 To frmgstprog.lstprog.ListCount - 1
If o Mod (saut) = 0 And o >= saut Then
Numero_colonne = Numero_colonne + 2
sh.Cells(1, Numero_colonne).Value = "n°card"
sh.Cells(1, Numero_colonne).Font.Bold = True
sh.Cells(1, Numero_colonne).Borders.Weight = Excel.XlBorderWeight.xlMedium
sh.Cells(1, Numero_colonne).HorizontalAlignment = Excel.xlHAlignCenter
sh.Cells(1, Numero_colonne + 1).Value = "n°prog"
sh.Cells(1, Numero_colonne + 1).Font.Bold = True
sh.Cells(1, Numero_colonne + 1).Borders.Weight = Excel.XlBorderWeight.xlMedium
sh.Cells(1, Numero_colonne + 1).HorizontalAlignment = Excel.xlHAlignCenter
End If
l = o Mod (saut) + 2
sh.Cells(l, Numero_colonne).Value = Left(frmgstprog.lstprog.List(o), InStrRev(frmgstprog.lstprog.List(o), "_") - 4)
sh.Cells(l, Numero_colonne).Borders.Weight = Excel.XlBorderWeight.xlThin
sh.Cells(l, Numero_colonne).Borders(Excel.XlBordersIndex.xlEdgeLeft).Weight = Excel.XlBorderWeight.xlThick
sh.Cells(l, Numero_colonne + 1).Value = Right(frmgstprog.lstprog.List(o), Len(frmgstprog.lstprog.List(o)) - InStrRev(frmgstprog.lstprog.List(o), "_"))
sh.Cells(l, Numero_colonne + 1).Borders.Weight = Excel.XlBorderWeight.xlThin
sh.Cells(l, Numero_colonne + 1).Borders(Excel.XlBordersIndex.xlEdgeRight).Weight = Excel.XlBorderWeight.xlThick
Next o
sh.Cells.EntireColumn.AutoFit
Set wk = Nothing
Set sh = Nothing |
Partager