Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExport.Click Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As New Excel.Worksheet Dim oRng As Excel.Range Dim i As Integer Dim j As Integer ' Start Excel and get Application object. xlApp = CreateObject("Excel.Application") xlApp.Visible = True ' Get a new workbook. xlWorkBook = xlApp.Workbooks.Add xlWorkSheet = xlWorkBook.ActiveSheet ' Add table headers going cell by cell. xlWorkSheet.Cells(1, 1).Value = "MANDT" xlWorkSheet.Cells(1, 2).Value = "BALEID" xlWorkSheet.Cells(1, 3).Value = "STATUS" xlWorkSheet.Cells(1, 4).Value = "CREEL1" xlWorkSheet.Cells(1, 5).Value = "CREEL2" xlWorkSheet.Cells(1, 6).Value = "CREEL3" xlWorkSheet.Cells(1, 7).Value = "CREEL4" xlWorkSheet.Cells(1, 8).Value = "CREEL5" xlWorkSheet.Cells(1, 9).Value = "CREEL6" xlWorkSheet.Cells(1, 10).Value = "CREEL7" xlWorkSheet.Cells(1, 11).Value = "CREEL8" xlWorkSheet.Cells(1, 12).Value = "ZPACKAGE" xlWorkSheet.Cells(1, 13).Value = "LOT" xlWorkSheet.Cells(1, 14).Value = "DISPOSITION" xlWorkSheet.Cells(1, 15).Value = "PROD_DATE" xlWorkSheet.Cells(1, 16).Value = "ZRELEASE" xlWorkSheet.Cells(1, 17).Value = "MATNR" xlWorkSheet.Cells(1, 18).Value = "WERKS" xlWorkSheet.Cells(1, 19).Value = "NETWR" xlWorkSheet.Cells(1, 20).Value = "GROWR" xlWorkSheet.Cells(1, 21).Value = "zFILE_NAME" xlWorkSheet.Cells(1, 22).Value = "STATUSP" xlWorkSheet.Cells(1, 23).Value = "EBELN" xlWorkSheet.Cells(1, 24).Value = "EBELP" ' Format A1:X1 as bold, vertical alignment = center. With xlWorkSheet.Range("A1", "X1") .Font.Bold = True .VerticalAlignment = Excel.XlVAlign.xlVAlignCenter End With For i = 0 To DataGridResults.RowCount - 1 For j = 0 To DataGridResults.ColumnCount - 1 xlWorkSheet.Cells(i + 2, j + 1) = _ DataGridResults(j, i).Value.ToString() Next Next ' AutoFit columns A:X. oRng = xlWorkSheet.Range("A1", "X1") oRng.EntireColumn.AutoFit() ' Make sure Excel is visible and give the user control ' of Excel's lifetime. xlApp.Visible = True xlApp.UserControl = True ' Make sure that you release object references. oRng = Nothing xlWorkSheet = Nothing xlWorkBook = Nothing xlApp.Quit() xlApp = Nothing Exit Sub Err_Handler: MsgBox(Err.Description, vbCritical, "Error: " & Err.Number) End Sub
xlWorkSheet.Cells(i + 2, j + 1) = _ DataGridResults(j, i).Value.ToString()