{"id":195,"date":"2013-04-22T11:33:04","date_gmt":"2013-04-22T16:33:04","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=195"},"modified":"2013-04-22T11:33:04","modified_gmt":"2013-04-22T16:33:04","slug":"vb-net-how-to-creae-excel-file-simple-example","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2013\/04\/22\/vb-net-how-to-creae-excel-file-simple-example\/","title":{"rendered":"VB.NET – How to creae Excel file – Simple example"},"content":{"rendered":"
1. Create new project
\n2. Add reference<\/p>\n

\"\"<\/p>\n

3. Select Microsoft.Office.Interop.Excel – ensure Excel is installed.\"\"<\/p>\n

4. Copy the following code – this will create simple Excel file in your C:\\Temp\\ExcelTest directory<\/p>\n

Dim fileTest As String = “C:\\Temp\\ExcelTest\\test.xlsx”
\nIf File.Exists(fileTest) Then
\nFile.Delete(fileTest)
\nEnd If<\/p>\n

Dim oExcel As Object
\noExcel = CreateObject(“Excel.Application”)
\nDim oBook As Excel.Workbook
\nDim oSheet As Excel.Worksheet<\/p>\n

oBook = oExcel.Workbooks.Add
\noSheet = oExcel.Worksheets(1)<\/p>\n

oSheet.Name = “Test Name”
\noSheet.Range(“A1”).Value = “SOME VALUE”
\noBook.SaveAs(fileTest)
\noBook.Close()
\noBook = Nothing
\noExcel.Quit()
\noExcel = Nothing<\/p>\n

5. More info on this video:<\/p>\n