linq to excel exception IErrorInfo.GetDescription

Question

This is my code

    var data = new LinqToExcel.ExcelQueryFactory();
                data.FileName = @"FRM_DTA.xlsx";                
                var result = from x in data.Worksheet<ExcelFileDefinition>()
                             select x;
Console.WriteLine(result.Count());

I got this exception:

OleDbException was unhandled

IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

on the console.write statement.

when I remove the console .write line, I got no exception

@Dalorzo I just tried your code and I got the exact same exception — Anastasie Laurent, Aug 10 '14 at 12:48
Hmm, that's pretty borken error handling in that library you are using. This is going to be a millstone around your neck if you don't address that, you don't stand much of a chance to assist your clients after your project ships. Don't use it. — Hans Passant, Aug 10 '14 at 13:57
@HansPassant it is working now. all i need the library is to read a very big excel sheet and transfer each row to a csv file and I did that now. — Anastasie Laurent, Aug 10 '14 at 14:07

score 4 · Accepted Answer · edited Aug 10 '14 at 14:46

4

The problem was the file name being incorrect. Changing that solved the problem.

edited Aug 10 '14 at 14:46

Patrick Hofman

153,850
22
249
325

answered Aug 10 '14 at 13:14

Anastasie Laurent

877
2
14
26

linq to excel exception IErrorInfo.GetDescription

1 Answers1