C# 读取Excel数据到DataSet

        /// <summary>         /// 读取Excel数据到DS         /// </summary>         /// <param name="excelName">xls文件路径(服务器物理路径)string RootDir =Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath.ToString());//获取程序根目录</param>         /// <returns></returns>         public DataSet ExcelReader(string excelName)         {             // 拼写连接字符串，打开连接             string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + excelName + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";             OleDbConnection objConn = new OleDbConnection(strConn);             objConn.Open();             // 取得Excel工作簿中所有工作表             DataTable schemaTable = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);             OleDbDataAdapter sqlada = new OleDbDataAdapter();             DataSet ds = new DataSet();             // 遍历工作表取得数据并存入Dataset             foreach (DataRow dr in schemaTable.Rows)             {                 string strSql = "Select * From [" + dr[2].ToString().Trim() + "]";                 OleDbCommand objCmd = new OleDbCommand(strSql, objConn);                 sqlada.SelectCommand = objCmd;                 sqlada.Fill(ds, dr[2].ToString().Trim());             }             objConn.Close();             return ds;         }