首页 / 网页编程 / ASP.NET / .NET中读取Excel文件的数据及excelReader应用

项目介绍
轻量，快速的C＃编写的库读取Microsoft Excel文件（"97-2007）。
跨平台：
- Windows with .Net Framework 2
- Windows Mobile with Compact Framework
- Linux, OS X, BSD with Mono 2+
如何使用
C# 代码：
复制代码 代码如下:
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（）;

VB.NET 代码：
复制代码 代码如下:
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.CreateBinaryReader（stream）
"...
"2. Reading from a OpenXml Excel file （2007 format; *.xlsx）
Dim excelReader As IExcelDataReader = ExcelReaderFactory.CreateOpenXmlReader（stream）
"...
"3. DataSet - The result of each spreadsheet will be created in the result.Tables
Dim result As DataSet = excelReader.AsDataSet（）
"...
"4. DataSet - Create column names from first row
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（）