Opening Excel file in VB.Net

[NekoManu]

I have never tried this before, so I have been looking for a workng example. So far no luck.

I want to open an Excel 2007 file in VB.Net. When I try I get an error: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

I have no idea what is going on.

This is the code Im using:

    Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click
        Dim xlApp As Excel.Application
        Dim xlWorkBook As Excel.Workbook
        Dim xlWorkSheet As Excel.Worksheet

        xlApp = New Excel.ApplicationClass
        xlWorkBook = xlApp.Workbooks.Open("C:\Test.xlsx")
        xlWorkSheet = xlWorkBook.Worksheets("sheet1")
        display the cells value B2
        MsgBox(xlWorkSheet.Cells(2, 2).value)
        edit the cell with new value
        xlWorkSheet.Cells(2, 2) = "http://vb.net-informations.com"
        xlWorkBook.Close()
        xlApp.Quit()

        releaseObject(xlApp)
        releaseObject(xlWorkBook)
        releaseObject(xlWorkSheet)
    End Sub
    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

 

[techmanbd]

It could be you are using an excel library in VB that is not compatible with the Excel program on the computer. I had the same problem a few years back, read this thread and it may help you. Using Late Binding is what you may need.

http://www.computerhelp.forum/showthread.php?t=79754&highlight=excel