Parsing excel files fails

Question

I have to pull data from an excel file. I was using the below piece of code since last year:

OleDbConnection cnn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + destFile + "; Extended Properties=Excel 12.0;");
string qText = @"select * from [sheetXY$]";
OleDbCommand oconn = new OleDbCommand(qText, cnn);
cnn.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(oconn);
adp.Fill(dt);
cnn.Close();

Since yesterday I get this error message: enter image description here

I had Office 2010 pro on my machine. According to some google suggestions I installed microsoft database access engine, made no difference. I re-installed whole office, made no difference. Then I installed Office 2013, no go.

What could possibly go wrong from a day to another, and how shall I fix it? I'm out of idea.

I was never successful reading Excel files in a reliable way using OLEDB. Sometimes filled cells are empty, you have to fiddle with your registry stackoverflow.com/questions/4551203/… and funny other things can happen. Nowadays I use epplus.codeplex.com or Aspose Cells for such tasks. — Andreas
– Andreas, Commented Jul 15, 2014 at 16:35
I had absolutely no issues till yesterday. I will try to find other, but similarly simple solutions. — fishmong3r
– fishmong3r, Commented Jul 15, 2014 at 16:43
Are you running on a 64-bit operating system and if so are you running the 32-bit or 64-bit copy of Office? If the former, then you need to make sure that you have installed the 32-bit version of the OLE drivers and also make sure your program is compiled for x86 mode — sgmoore
– sgmoore, Commented Jul 15, 2014 at 16:45

Dbloch · Accepted Answer · 2014-07-18 13:27:50Z

7

+50

Save yourself time and headache and use EPPLUS instead. EPPLUS can be installed via Nuget and you don't have to deal with installing the Office Data access on other machine where your code runs.

edited Jul 18, 2014 at 13:27

answered Jul 18, 2014 at 13:11

Dbloch

2,4061 gold badge16 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

fishmong3r Over a year ago

This sounds great. Though I don't even know what Nuget is. Can you provide link to examples on how EEPLUS should be used to read xlsx files?

fishmong3r Over a year ago

Never mind. I found a great example. Now I can parse properly. But to be able to use this function EPPLUS.dll has to be in the same directory as my executable. So we have arrived to the question of installtion of it. Can you help me?

Dbloch Over a year ago

What development tool are you using Visual Studio? If so, what version?

vishnu · Accepted Answer · 2014-07-21 05:33:28Z

0

You can go for openXML SDK. Which requires no machine level dependency.

http://www.codeproject.com/Articles/371203/Creating-basic-Excel-workbook-with-Open-XML

http://msdn.microsoft.com/en-us/library/office/gg575571(v=office.15).aspx

answered Jul 21, 2014 at 5:33

vishnu

131 silver badge4 bronze badges

Collectives™ on Stack Overflow

Parsing excel files fails

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related