项目介绍

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