Open-source Excel file reader component-exceldatareader
Exceldatareader can read Microsoft Excel files ('97-2007) and supports windows. NET Framework 2 + and Windows Mobile with Compact framework
, Linux, OS X, BSD with mono 2. Address: http://exceldatareader.codeplex.com/
The usage is very simple:
Filestream stream = file. Open (filepath, filemode. Open, fileaccess. Read );
// 1. reading from a binary Excel file ('97-2003 format; *. xls)
Iexceldatareader excelreader = excelreaderfactory. createbinaryreader (Stream );
//...
// 2. reading from a openxml Excel file (2007 format; *. XLSX)
Iexceldatareader excelreader = excelreaderfactory. createopenxmlreader (Stream );
//...
// 3. dataset-the result of each spreadsheet will be created in the result. Tables
Dataset result = excelreader. asdataset ();
//...
// 4. dataset-create column names from first row
Excelreader. isfirstrowascolumnnames = true;
Dataset result = excelreader. asdataset ();
// 5. Data reader Methods
While (excelreader. Read ())
{
// Excelreader. getint32 (0 );
}
// 6. free resources (iexceldatareader is idisposable)
Excelreader. Close ();