本文共 1100 字,大约阅读时间需要 3 分钟。
需要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; }转载地址:http://phumf.baihongyu.com/