ExcelDataReader v.

Rating:        Based on 33 ratings
Reviewed:  29 reviews
Downloads: 57924
Released: Aug 24, 2009
Updated: Aug 24, 2009 by iciobanu
Dev status: Stable Help Icon

Recommended Download

Application ExcelDataReader_2.0.1.0.zip
application, 204K, uploaded Aug 24, 2009 - 57924 downloads

Release Notes

ExcelDataReader maintenance release.

Various bugs fixed.

Reviews for this release

I have a semi-complex macro-enabled spreadsheet created in Excel 2010 with multiple tabs, merged cells, and various text and numeric fields both empty and filled. Unfortunately, this library has enough bugs to make it useless. Reading across a row results in some values picked up from other rows, or snippets of mysterious truncated xml. Sheet name reading is mixed up.
by tacotortilla on Dec 5, 2012 at 2:35 PM
First attempts at this library were promising... but it is WAY too fragile for serious use. Having empty left most fields wrecks the next one along if also empty. Pity - could have been handy.
by crogers on Sep 11, 2012 at 2:45 AM
Works like a charm, and easy to use.
by cypher0six on Aug 28, 2012 at 9:41 PM
Nice job. Although In xls works perfectly but in xlsx format columns are displaced in the output dataset
by nkritikos on Jun 6, 2012 at 2:33 PM
This has lots of bugs , like date getting converted to integer and then some of the values are not being read , and sometimes dataset returned is out of place like column into rows etc.. This is not at all reliable and hence not usable
by Akshayk2 on Jun 4, 2012 at 5:34 PM
Out of four projects I evaluated today for reading an xls this was the one I selected as best fit for my purpose - simple efficient compact *self contained* and does exactly what is says it will. Previously I was using the OleDbConnection JET4.0 - but dropped JET because it was broken, this project, on the other hand, works well.
by RichardHarrison on May 24, 2012 at 8:55 PM
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); I am facing Object reference error at this line, some help me here.
by venkates999 on Apr 25, 2012 at 12:28 PM
Design and usage are great. So far only issue I've had is with certain XLSX file not parsing correctly (reading in wrong sheets, missind cell values, etc). To resolve these issues, I had to rebuild Excel.dll using latest SharpZipLib from http://www.icsharpcode.net/OpenSource/SharpZipLib/Download.aspx. As others have said, project needs an update, but is still good.
by Hossrod on Mar 6, 2012 at 6:12 PM
It was very easy to setup and work perfectly.
by rmizrachi on Oct 31, 2011 at 5:33 AM
So far it handles what I need it to, but it uses an older version of SharplibZip that what I use, which has forced me to remove the code and create a separate dll from it which was kind of a waste of time. It needs an upgrade. Worth the use and a small donation.
by crtjr on Oct 28, 2011 at 5:16 PM
This is great software. Good easy to understand interface, and works as expected.
by dacris on Oct 17, 2011 at 4:12 PM
Great Work Solved my major work on excel importing.
by scerejo on Aug 12, 2011 at 2:42 PM
Thanks that's great. I've used v2.0.1.0 on Windows 2008 R2 - 64-bit with no problem
by bmsvic on Jun 30, 2011 at 2:51 AM
Awsome work. Thank you so much. But is there any 64 bit version available?
by saanjs on Jun 6, 2011 at 10:51 AM
Excel Data Reader works well; we have been able to use it to successfully read both XLS and XLSX files. The performance is much better than COM interop.
by Verious on Feb 7, 2011 at 6:59 PM
Excellent and easy to use library
by Mr_T on Feb 2, 2011 at 8:22 AM
It's a great alternative to read Excel files avoiding OpenRowSet. Congratulations for the initiative. My tests included simple Excel 2003 files and Excel 2007 files. To read some Excel 2007 files correctly (converted from 2003 version) , I got the last source code version (2.1) and I used it.
by rafaporci on Feb 2, 2011 at 2:24 AM
Excellent dll.
by saunde on Dec 6, 2010 at 3:44 PM
The fastest and best free library for reading Excel files. Not without its problems, but a lot of the patches submitted over the last year deal with some of the issues (see patches section). However the developers need to pull their fingers out and put together another release utilising these patches.
by robalexclark on Sep 9, 2010 at 3:44 PM
Don't waste your time with this software. If column A has an empty cell and column B's cell contains true/false column B is read as System.DBNull. But if column A has data in it then the true/false in column B is read as 1/0. And the example code is wrong. Setting IsFirstRowAsColumnNames must be done BEFORE invoking AsDataSet.
by bill_flynn on Aug 4, 2010 at 8:44 PM
Failed to perform a simple task of reading all sheet names from excel 2007 file. Displayed 12 of 15 only. What else left to appreciate this release?
by syedemad on Aug 3, 2010 at 9:31 AM
Silently fails to read some xlsx files entirely. Reads DBNULL into some columns that have content in them. Incorrectly reads datetime values from xls files. Buggy to the point of being unusable and hasn't had a stable release in over a year.
by dgcoffman on Jul 9, 2010 at 6:51 PM
Easiest way to writing to excel using c#, I use it long time, name Spire.XLS, may help to you. http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html
by harrypeter86 on Jul 9, 2010 at 3:19 AM
A good library for replacing OLE DB or COM access to Excel files. Should incorporate some of the suggested patches to deal correctly with whitespace nodes and dates in xlsx files.
by rick_townsend on May 18, 2010 at 3:24 AM
Very nice, I have tried it with the typical XLS and it works great. I can not seem to get it to work with the XLSX but i will continue to see if i am doing something wrong,
by cgarrity on May 9, 2010 at 3:08 AM
Very good component, is quite faster than Microsoft's office interop component.
by Kriss on Mar 12, 2010 at 9:01 AM
It's very powerful, but I am waiting for your next version to support Excel 2007 xlsx format file reading capabilities.
by firstsee on Dec 23, 2009 at 7:32 AM
Contains everything i needed and more!
by theo1985 on Dec 21, 2009 at 4:16 PM
In my opinion, Excel Data Reader is the easiest way to access an excel file without any unnecessary overhead. This library saved a lot of my time.
by Kenrik on Oct 20, 2009 at 9:13 PM