Asp.net 读取EXCEL2007/2003 数据

Public DataTable GetDataTableFromExcel(string fileName,string tableName )

{

string connStr = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info=False;Extended Properties=Excel 8.0; data source=文件路径" 

string sql = "SELECT * FROM [" + tableName + "]";

OleDbConnection conn = new OleDbConnection(connStr);

try

{

   conn.Open();

   DataSet ds = new DataSet();

   OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);

   da.Fill(ds);

}

catch (Exception)

{

     throw;

}

finally

{

    conn.Close();

}

}

 

Microsoft.ACE.OLEDB.12.0:odbc驱动程序可以读取*.xls,*.xlsx,*.xlsm,*.xlsb格式的文件。