C#编程读取Excel数据到DataTable

/// <summary>
        /// 读取Excel文件到datatable中
        /// </summary>
        /// <param name="excelpath">execl路径</param>
        /// <returns></returns>
        private DataTable ReaderExcel(string excelpath)
        {
            OleDbConnection conn;
            DataTable dt = new DataTable();
            OleDbDataAdapter odda;
            DataSet ds;
            string path = Server.MapPath("\\UploadFiles\\main\\Files\\" + excelpath);
            if (!File.Exists(path))
            {
                return dt;
            }
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;IMEX=1\"";
            //string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;IMEX=1";
            conn = new OleDbConnection(strConn);
            conn.Open();
            dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            string SheetName = dt.Rows[0]["TABLE_NAME"].ToString();
            string strsql = "select * from [" + SheetName + "]";
            odda = new OleDbDataAdapter(strsql, conn);
            ds = new DataSet();
            odda.Fill(ds);
            dt = ds.Tables[0];
            conn.Dispose();
            conn.Close();
            return dt;