LinqToExcel sometimes results in IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

Question

Sometimes when running the code below it results in the error IErrorInfo.GetDescription failed with E_FAIL(0x80004005) from the call to excelFile.WorksheetNoHeader(0).

It doesn't seem to depend on the excel file, one file can be readable one time and the next time not.

Any ideas what could be the cause?

    Public Overrides Function GetImportDataAsDataTable() As DataTable
        Dim dataTable = New DataTable
        dataTable.BeginLoadData()
        Try
            Dim excelFile = New ExcelQueryFactory(FileFullPath)
            For Each importDataRow In excelFile.WorksheetNoHeader(0)
                If dataTable.Columns.Count = 0 Then
                    For i = 1 To importDataRow.Count
                        dataTable.Columns.Add(New DataColumn())
                    Next
                End If
                Dim dataRow = dataTable.NewRow
                dataRow.ItemArray = importDataRow.ToArray
                dataTable.Rows.Add(dataRow)
            Next
        Finally
            dataTable.EndLoadData()
        End Try
        Return dataTable
    End Function

score 1 · Answer 1 · answered Jun 29 '12 at 14:12

1

It's an OleDb error.

It looks like a reserved sql word was used. Check out this post for more information: http://forums.asp.net/t/1225443.aspx/1

answered Jun 29 '12 at 14:12

Paul

18,349
7
49
56

Nope, can't be that. I'm just calling the "WorkSheetNoHeaderMethod" and not specifying any columns. And one file sometimes works and sometimes not. – Carl Björknäs Jul 04 '12 at 15:32
Carl, did you ever get this sorted out..?? – Ads Sep 24 '13 at 00:42

LinqToExcel sometimes results in IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

1 Answers1