ExcelDataReader v2.1

Rating:        Based on 14 ratings
Reviewed:  13 reviews
Downloads: 35182
Change Set: 82323
Released: Jan 17, 2013
Updated: Feb 13, 2013 by Ian1971
Dev status: Beta Help Icon

Recommended Download

Application 2.1 Binary
application, 150K, uploaded Jan 17, 2013 - 27814 downloads

Other Available Downloads

Source Code 2.1 Source
source code, 1734K, uploaded Jan 17, 2013 - 7368 downloads

Release Notes

  • Open Office 3 generated xls file support.
  • Data types preserved in datasets
  • Duplicate column names handled in datasets
  • Fix problems with empty sheets and xlsx
  • Fix problems detecting dates in xls e.g. currency being detected as a date
  • Fix problems with blank columns in xlsx
  • Fix problems with temp file locking in xlsx

In particular for the Open Office support it now supports short stream formats in xls documents and worksheets with no INDEX or DBCELL records. This probably helps with documents generated from other tools as well.

Reviews for this release

My need was to read the values from a xlsx file as strings. It was very easy and simple to use. Worked perfectly!
by andrenascentes on Jan 29, 2014 at 8:16 PM
Very useful
by Jotch on Jan 16, 2014 at 7:15 PM
Works perfectly for me: open a 2013 xslx and read all it's data. Thanks a million!
by Rickenberg on Jan 7, 2014 at 11:37 AM
Works great and helps processing Excel files very good.
by petermorlion on Aug 12, 2013 at 3:59 PM
Awesome! Rockstars!
by frookypoon on Jun 27, 2013 at 11:45 AM
Saved me huge amounts of time developing our internal Excel conversion tools.
by SteveHolle on May 22, 2013 at 3:27 PM
Great project, very easy to setup and start using. Thanks!!
by tsiqueira on May 10, 2013 at 9:36 PM
Nice work, keep it up, very useful. Looking forward for the binary 2007 support
by stevozilik on Apr 22, 2013 at 5:11 PM
Love it, when will the BinaryReader be avail for 2007+ excel?
by TMcKeown6869 on Apr 8, 2013 at 2:17 PM
GRRRRRRREAT JOB!!! Just Saved us from committing crime of version specific Interoperablity. Keep It up. Looking forward for Office2010 & Office2013 releases
by anurag_its on Mar 28, 2013 at 10:27 PM
Very useful!!! This should be in .Net Library
by ImportantDude on Feb 11, 2013 at 3:03 PM
Thank you all VERY much for maintaining this project. Compared with Microsoft's ACE driver, this is a dream.
by wolfeitz on Feb 1, 2013 at 12:49 PM
Although it now returns a datatable with the correct no. of rows, all the values in all the rows are empty, when I try to read a file with no INDEX record. So the issue with files with no INDEX still remains.
by geetmenon on Jan 25, 2013 at 11:20 PM