C#获取Excel全部的sheet

        /// <summary>
        /// 获取Excel全部的sheet
        /// </summary>
        /// <param name="filepath"></param>
        /// <returns></returns>
        public static List<string> ExcelSheetName(string filepath)
        {
            //StringCollection names = new StringCollection();
            List<string> names = new List<string>();
            string strConn;
            strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=2'";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            DataTable sheetNames = conn.GetOleDbSchemaTable
            (System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            conn.Close();

            foreach (DataRow dr in sheetNames.Rows)
            {
                names.Add(dr[2].ToString());
            }
            return names;
        }