需要using using System.Data.OleDb;
如果是2007以上的excel文件需要安装AccessDatabaseEngine.exe
下面是实现过程
public DataTable GetDataFromExcel(string filePath)
{string connStr = "";
string fileType = System.IO.Path.GetExtension(filePath);
if (string.IsNullOrEmpty(fileType)) return null;
if (fileType == ".xls")
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
else
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";" + ";Extended Properties=\"Excel 12.0;HDR=NO;IMEX=1\"";
string sql_F = "Select * FROM [{0}] ";
OleDbConnection conn = null;
OleDbDataAdapter da = null;
DataTable dataTable = new DataTable();
try
{
// 初始化连接，并打开
conn = new OleDbConnection(connStr);
conn.Open();
da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand(String.Format(sql_F, "Sheet1$"), conn);
da.Fill(dataTable);
}
catch (Exception ex)
{
}
finally
{ // 关闭连接
if (conn.State == ConnectionState.Open)
{
conn.Close();
da.Dispose();
conn.Dispose();
}
}
conn.Close();
da.Dispose();
conn.Dispose();
return dataTable;
}