Exemplo n.º 1
0
        //检查该EXCEL是否有该表存在
        /// <summary>
        /// 检查该EXCEL是否有该表存在
        /// </summary>
        /// <param name="excel"></param>
        /// <param name="shellName"></param>
        /// <returns></returns>
        public static bool CheckTableExsit(ExcelHelper excel, string shellName)
        {
            DataTable dtSchema = excel.GetSchema();

            return (from DataRow dr in dtSchema.Rows select dr["TABLE_NAME"].ToString()).Select(name => name == shellName).FirstOrDefault();
        }