Project Hosting for Open Source Software
Excel Data Reader - Read Excel files in .NET
All Project Updates
Wiki & Documentation
Based on 33 ratings
Aug 24, 2009
Aug 24, 2009
application, 204K, uploaded
Aug 24, 2009
- 57501 downloads
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.
Dec 5, 2012 at 1: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.
Sep 11, 2012 at 1:45 AM
Works like a charm, and easy to use.
Aug 28, 2012 at 8:41 PM
Nice job. Although In xls works perfectly but in xlsx format columns are displaced in the output dataset
Jun 6, 2012 at 1: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
Jun 4, 2012 at 4: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.
May 24, 2012 at 7:55 PM
IExcelDataReader excelReader = ExcelReaderFactory.Create
OpenXmlReader(stream); I am facing Object reference error at this line, some help me here.
Apr 25, 2012 at 11:28 AM
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.ne
Download.aspx. As others have said, project needs an update, but is still good.
Mar 6, 2012 at 5:12 PM
It was very easy to setup and work perfectly.
Oct 31, 2011 at 4: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.
Oct 28, 2011 at 4:16 PM
This is great software. Good easy to understand interface, and works as expected.
Oct 17, 2011 at 3:12 PM
Great Work Solved my major work on excel importing.
Aug 12, 2011 at 1:42 PM
Thanks that's great. I've used v220.127.116.11 on Windows 2008 R2 - 64-bit with no problem
Jun 30, 2011 at 1:51 AM
Awsome work. Thank you so much. But is there any 64 bit version available?
Jun 6, 2011 at 9: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.
Feb 7, 2011 at 5:59 PM
Excellent and easy to use library
Feb 2, 2011 at 7: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.
Feb 2, 2011 at 1:24 AM
Dec 6, 2010 at 2: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.
Sep 9, 2010 at 2: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.
Aug 4, 2010 at 7: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?
Aug 3, 2010 at 8: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.
Jul 9, 2010 at 5: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/
Jul 9, 2010 at 2: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.
May 18, 2010 at 2: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,
May 9, 2010 at 2:08 AM
Very good component, is quite faster than Microsoft's office interop component.
Mar 12, 2010 at 8:01 AM
It's very powerful, but I am waiting for your next version to support Excel 2007 xlsx format file reading capabilities.
Dec 23, 2009 at 6:32 AM
Contains everything i needed and more!
Dec 21, 2009 at 3: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.
Oct 20, 2009 at 8:13 PM
Opera does not support ClickOnce
To install this application, save it and then open it. Opening it directly from Opera will not work correctly.
Jan 30, 2014
Jan 17, 2013
Latest Source Code
Dec 18, 2012
Aug 24, 2009
May 12, 2009
eader v1.1 beta1
Apr 12, 2009
Oct 17, 2008
There are no Planned releases for this project.
to display notification settings.
(change e-mail address)
Also stop notifications for
issue(s) I subscribed to.
© 2006-2014 Microsoft
Code of Conduct
Advertise With Us