ExcelDataReader v2.1

Rating:        Based on 14 ratings
Reviewed:  13 reviews
Downloads: 33923
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 - 27056 downloads

Other Available Downloads

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

Release Notes

Changes
  • 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 at 7:16 PM
     
Very useful
by Jotch on Jan 16 at 6:15 PM
     
Works perfectly for me: open a 2013 xslx and read all it's data. Thanks a million!
by Rickenberg on Jan 7 at 10:37 AM
     
Works great and helps processing Excel files very good.
by petermorlion on Aug 12, 2013 at 2:59 PM
     
Awesome! Rockstars!
by frookypoon on Jun 27, 2013 at 10:45 AM
     
Saved me huge amounts of time developing our internal Excel conversion tools.
by SteveHolle on May 22, 2013 at 2:27 PM
     
Great project, very easy to setup and start using. Thanks!!
by tsiqueira on May 10, 2013 at 8:36 PM
     
Nice work, keep it up, very useful. Looking forward for the binary 2007 support
by stevozilik on Apr 22, 2013 at 4:11 PM
     
Love it, when will the BinaryReader be avail for 2007+ excel?
by TMcKeown6869 on Apr 8, 2013 at 1: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 9:27 PM
     
Very useful!!! This should be in .Net Library
by ImportantDude on Feb 11, 2013 at 2: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 11:49 AM
     
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 10:20 PM