Project Introduction
Lightweight, Fast C # written library reads Microsoft Excel file (' 97-2007).
Cross-platform:
-Windows with. Net Framework 2
-Windows Mobile with Compact Framework
-Linux, OS X, BSD with Mono
How to use
C # code:
Copy Code code as follows:
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 is created in the result. Tables
DataSet result = Excelreader.asdataset ();
//...
4. Dataset-create column names from the
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 ();
VB.net code:
Copy Code code as follows:
Dim stream as FileStream = File.Open (FilePath, FileMode.Open, FileAccess.Read)
' 1. Reading from a binary Excel file (' 97-2003 format; *.xls ')
Dim excelreader as Iexceldatareader = excelreaderfactory.c Reatebinaryreader (Stream)
' ...
' 2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
Dim excelreader as Iexceldatareader = Excelreaderfactory.cre Ateopenxmlreader (Stream)
' ...
' 3. dataset-the result of each spreadsheet is created in the result. Tables
Dim result as DataSet = Excelreader.asdataset ()
' ...
' 4. Dataset-create column names from-i
Excelreader.isfirstrowascolumnnames = True
Dim result as DataSet = Excelreader.asdataset ()
' 5. Data Reader Methods
while Excelreader.read ()
' Excelreader.getint32 (0);
End While
' 6. Free resources (Iexceldatareader is IDisposable)
Excelreader.close ()