轻量，快速的C＃编写的库读取Microsoft Excel文件,这对读取大量excel文件的朋友们很有帮助而且可以学习下ExcelDataReader的应用，感兴趣的朋友可以了解下，或许对你有所帮助
项目介绍
轻量，快速的C＃编写的库读取Microsoft Excel文件（’97-2007）。
跨平台：
– Windows with .Net Framework 2
– Windows Mobile with Compact Framework
– Linux, OS X, BSD with Mono 2+
如何使用
C# 代码：
轻量，快速的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();
//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 IExcelDataRea来源gao@daima#com搞(%代@#码网der = 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()
‘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 IExcelDataRea来源gao@daima#com搞(%代@#码网der = 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()
以上就是.NET中读取Excel文件的数据及excelReader应用的详细内容，更多请关注gaodaima搞代码网其它相关文章！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：.NET中读取Excel文件的数据及excelReader应用
转载请注明原文链接：.NET中读取Excel文件的数据及excelReader应用
