遍歷指定文件夾下Excel文件,并進行讀取出來

/// <summary>
        /// 遍歷指定文件夾下Excel文件,并進行讀取出來
        /// </summary>
        /// <param name="dirPath">指定文件夾目录</param>
        public void GetExcelInfo(string dirPath)
        {
            //在指定目录及子目录下查找文件,在listBox1中列出子目录及文件
            DirectoryInfo Dir = new DirectoryInfo(dirPath);
            FileAttributes fa;
            try
            {
                foreach (DirectoryInfo d in Dir.GetDirectories())//查找子目录
                {
                    fa = d.Attributes & FileAttributes.Hidden;
                    if (fa == FileAttributes.Hidden)
                    {
                        continue;
                    }
                    fa = d.Attributes & FileAttributes.System;
                    if (fa == FileAttributes.System)
                    {
                        continue;
                    }
                    fa = d.Attributes & FileAttributes.Temporary;
                    if (fa == FileAttributes.Temporary)
                    {
                        continue;
                    }
                    GetExcelInfo(Dir + "\\" + d.ToString() + "\\");
                }
                foreach (FileInfo f in Dir.GetFiles("*.xls")) //查找文件
                {
                    if (f.Name.IndexOf("CARD_DSN_DDS_") > -1)
                    {
                        str_TempList = f.Name.Split('.');
                        s_Temp = str_TempList[0].Replace("CARD_DSN_DDS_", "");
                        if (!hash_ExcelMark.ContainsKey(s_Temp))
                        {
                            FileAttributes MyAttributes = File.GetAttributes(f.FullName);

                            if ((MyAttributes & FileAttributes.System) == FileAttributes.System)
                            {
                                continue;
                            }
                            if ((MyAttributes & FileAttributes.Hidden) == FileAttributes.Hidden)
                            {
                                continue;
                            }
                            if ((MyAttributes & FileAttributes.Temporary) == FileAttributes.Temporary)
                            {
                                continue;
                            }

                            hash_ExcelMark.Add(s_Temp, ExcelClass.GetExcelRemarkForNpoi(f.FullName));
                        }
                    }
                }
                foreach (FileInfo f in Dir.GetFiles("*.xlsx")) //查找文件
                {
                    if (f.Name.IndexOf("CARD_DSN_DDS_") > -1)
                    {
                        str_TempList = f.Name.Split('.');
                        s_Temp = str_TempList[0].Replace("CARD_DSN_DDS_", "");
                        if (!hash_ExcelMark.ContainsKey(s_Temp))
                        {
                            FileAttributes MyAttributes = File.GetAttributes(f.FullName);
                            if ((MyAttributes & FileAttributes.System) == FileAttributes.System)
                            {
                                continue;
                            }
                            if ((MyAttributes & FileAttributes.Hidden) == FileAttributes.Hidden)
                            {
                                continue;
                            }
                            if ((MyAttributes & FileAttributes.Temporary) == FileAttributes.Temporary)
                            {
                                continue;
                            }
                            hash_ExcelMark.Add(s_Temp, ExcelClass.GetExcelRemarkForNpoi(f.FullName));
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }