VB.NET - How to creae Excel file - Simple example

1. Create new project
2. Add reference




     
3. Select Microsoft.Office.Interop.Excel - ensure Excel is installed.


4. Copy the following code - this will create simple Excel file in your C:\Temp\ExcelTest directory

Dim fileTest As String = "C:\Temp\ExcelTest\test.xlsx"
        If File.Exists(fileTest) Then
            File.Delete(fileTest)
        End If

        Dim oExcel As Object
        oExcel = CreateObject("Excel.Application")
        Dim oBook As Excel.Workbook
        Dim oSheet As Excel.Worksheet

        oBook = oExcel.Workbooks.Add
        oSheet = oExcel.Worksheets(1)

        oSheet.Name = "Test Name"
        oSheet.Range("A1").Value = "SOME VALUE"
        oBook.SaveAs(fileTest)
        oBook.Close()
        oBook = Nothing
        oExcel.Quit()
        oExcel = Nothing

5. More info on this video: