C# 获得.xls文件的内容 获得.xls文件中的表名

private void ExcelToDS(string Path)   
        {   
            string clientFilePath = FileUpload1.PostedFile.FileName;       //客户端文件的物理路径   
  
            int i = clientFilePath.LastIndexOf("."); //取得文件名中最后一个"."的索引   
            string extension = clientFilePath.Substring(i); //获取文件扩展名   
  
            if (extension != ".xls")   
            {   
                MsgBox.Alert("文件必须为.xls格式！", "ImportTeacherDate.aspx");   
                return;   
            }   
            else  
            {   
                string myConn = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + clientFilePath + "';Extended Properties=Excel 8.0";   
  
                OleDbConnection cnnxls = new OleDbConnection(myConn);   
  
                DataSet myDataSet = new DataSet();   //创建DataSet对象      
  
                cnnxls.Open();   
                DataTable dt = cnnxls.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);   
                string StyleSheet = dt.Rows[0][2].ToString().Trim();    //.xls的第一个表名   
  
                string StrSql = string.Format("SELECT * FROM [{0}]", StyleSheet);   
                OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);   
                myCommand.Fill(myDataSet, string.Format("[{0}]", StyleSheet));   
                myCommand.Dispose();   
                DataTable DT = myDataSet.Tables[string.Format("[{0}]", StyleSheet)];   
  
                for (int j = 0; j < DT.Rows.Count; j++)   
                {   
                    try  
                    {   
                        string userLogin = BusinessFacadeFrameWork.get_table_fileds("FrameWork_Member", "Name", "Name", DT.Rows[j][0].ToString().Trim());   
                        if (!string.IsNullOrEmpty(userLogin))   
                        {   
                            MsgBox.Alert(string.Format("添加教师失败！{0}的登录名已存在！", DT.Rows[j][0].ToString()), "ImportTeacherDate.aspx");   
                            return;   
                        }   
                        else  
                        {   
                            //向用户表内添加老师基本信息   
                            FrameWork_MemberEntity me = new FrameWork_MemberEntity();   
                            me.DataTable_Action_ = DataTable_Action.Insert;   
                            me.Name = DT.Rows[j][0].ToString().Trim();   
                            me.PSW = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile("123456", "MD5").ToUpper();   
                            me.RegTime = DateTime.Now;   
                            me.TrueName = DT.Rows[j][1].ToString().Trim();   
                            me.MemberRoleID = 6;   
                            int rInt = BusinessFacadeFrameWork.FrameWork_MemberInsertUpdateDelete(me);   
                            if (rInt < 1)   
                            {   
                                MsgBox.Alert("向用户表内添加老师基本信息失败！", "ImportTeacherDate.aspx");   
                                return;   
                            }   
                            else  
                            {   
                                //向教师表内添加教师详细信息   
                                FrameWork_TeacherEntity te = new FrameWork_TeacherEntity();   
                                te.DataTable_Action_ = DataTable_Action.Insert;   
                                te.cLogin = DT.Rows[j][0].ToString().Trim();   
                                te.cName = DT.Rows[j][1].ToString().Trim();   
                                te.cIntro = DT.Rows[j][2].ToString().Trim();   
                                te.cPos = DT.Rows[j][3].ToString().Trim();   
                                te.cPhoto = DT.Rows[j][4].ToString().Trim();   
                                te.cTeacherCode = AdminLoginInfo.CCode;   
                                te.cTeachTel = DT.Rows[j][5].ToString().Trim();   
                                int rInt_te = BusinessFacadeFrameWork.FrameWork_TeacherInsertUpdateDelete(te);   
                                if (rInt_te < 1)   
                                {   
                                    MsgBox.Alert("向用户表内添加老师基本信息失败！", "ImportTeacherDate.aspx");   
                                    return;   
                                }   
                            }   
                        }   
                    }   
                    catch (Exception ex)   
                    {   
                        MsgBox.Alert("用户提供的表格格式不正确", "ImportTeacherDate.aspx");   
                        return;   
                    }   
                }   
                cnnxls.Close();   
                MsgBox.Alert("导入教师数据成功！", "TeacherList.aspx?ModelID=500");   
            }   
        }