1、Excel 需是.xls 格式

2、添加引用Microsoft.Office.Interop.Excel.dll

复制代码 代码如下:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.OleDb;

using Excel = Microsoft.Office.Interop.Excel;

using System.Diagnostics;

namespace ReadExcel

{

class Program

{

static void Main(string[] args)

{

string fileName = @"D:TransferPlant111.xls";

DataTable dt = ExcelToDataSet(fileName);

if (dt.Rows.Count > 0)

{

for (int i = 0; i < dt.Rows.Count; i++)

{

Console.WriteLine(dt.Rows[i][0].ToString());

}

}

}

static public DataTable ExcelToDataSet(string filename)

{

string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = "+filename+";Extended Properties=Excel 8.0";

OleDbConnection conn = new OleDbConnection(strCon);

conn.Open();

//返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等

DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });

//包含excel中表名的字符串数组

string[] strTableNames = new string[dtSheetName.Rows.Count];

for (int k = 0; k < dtSheetName.Rows.Count; k++)

{

strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();

}

OleDbDataAdapter myCommand = null;

DataTable dt = new DataTable();

//从指定的表明查询数据,可先把所有表明列出来供用户选择

string strExcel = "select * from [" + strTableNames[0] + "]";

myCommand = new OleDbDataAdapter(strExcel, strCon);

myCommand.Fill(dt);

return dt;

}

}

}