.NET中读取Excel文件的数据及excelReader应用

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

项目介绍
轻量，快速的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() 