Function plop() Dim ds As New DataSet Dim dvSU2PC As New DataView Dim dvPC2SU As New DataView Dim i As Integer Dim MyExcel As Excel.Application Dim MyWorkBook As Excel.Workbook Dim MyWorkSheet As Excel.Worksheet ds.ReadXml("Trace.xml") 'init Dataviews & bindings dvSU2PC = ds.DefaultViewManager.CreateDataView(ds.Tables(0)) dvPC2SU = ds.DefaultViewManager.CreateDataView(ds.Tables(1)) MyExcel = New Excel.Application MyExcel.Visible = False MyWorkBook = MyExcel.Workbooks.Open("D:\Trace.xls") MyWorkSheet = MyWorkBook.ActiveSheet ' Export Datas MyWorkSheet.Cells(1, 1) = "SU to PC" MyWorkSheet.Cells(1, 2) = "PC to SU" MyWorkSheet.Cells(1, 1).Font.Bold = True MyWorkSheet.Cells(1, 2).Font.Bold = True Dim dr As DataRowView i = 2 For Each dr In dvSU2PC MyWorkSheet.Cells(i, 1) = dr.Item("SU2PC") i = i + 1 Next i = 2 For Each dr In dvPC2SU MyWorkSheet.Cells(i, 2) = dr.Item("PC2SU") i = i + 1 Next 'Autofit the cells MyWorkSheet.Cells(1, 1).CurrentRegion.EntireColumn.AutoFit() MyWorkBook.Save() MyWorkBook.Close() End Function
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question