项目介绍
轻量，快速的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()
您可能感兴趣的文章:

  • ASP.NET(C#)读取Excel的文件内容
  • .net客户端导出Excel实现代码及注意事项
  • .Net中导出数据到Excel(asp.net和winform程序中)
  • asp.net生成Excel并导出下载五种实现方法
  • C#数据导入/导出Excel文件及winForm导出Execl总结
  • ASP.NET下将Excel表格中的数据规则的导入数据库思路分析及实现
  • ASP.NET导出Excel打开时提示:与文件扩展名指定文件不一致解决方法
  • asp.net Grid 导出Excel实现程序代码
  • C#实现EXCEL数据到TXT文档的转换
声明：本站（华域联盟www.cnhackhy.com）所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。