ExcelDataReader v2.1

Rating:        Based on 8 ratings
Reviewed:  7 reviews
Downloads: 11063
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 - 8825 downloads

Other Available Downloads

Source Code 2.1 Source
source code, 1734K, uploaded Jan 17 - 2238 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

     
Great project, very easy to setup and start using. Thanks!!
by tsiqueira on May 10 at 8:36 PM
     
Nice work, keep it up, very useful. Looking forward for the binary 2007 support
by stevozilik on Apr 22 at 4:11 PM
     
Love it, when will the BinaryReader be avail for 2007+ excel?
by TMcKeown6869 on Apr 8 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 at 9:27 PM
     
Very useful!!! This should be in .Net Library
by ImportantDude on Feb 11 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 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 at 10:20 PM