处理文件夹下所有excel读取

 public void runexcle()
    {
        string path1 = @"F:\excel\";
        DirectoryInfo folder = new DirectoryInfo(path1);
        int PI_IssueNum = 0;
        foreach (FileInfo file in folder.GetFiles("*.xls"))
        {
            string path = file.FullName;
            string truename = path.Replace(@"F:\excle\", "").Replace(".xlsx", "").Replace(".xls", "");//
            PI_IssueNum++;
            EA_UserInfo eA_UserInfo = EA_UserInfoBz.GetModelOne("truename='" + truename + "'", "*");
            if (eA_UserInfo == null)
            {
                Console.WriteLine("");
            }
            string StrConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "Data Source=" + path + ";Extended Properties='Excel 12.0; HDR=NO; IMEX=1'";
            using (OleDbConnection conn = new OleDbConnection(StrConn))
            {
                conn.Open();
                DataTable sheetsName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" }); //得到所有sheet的名字  
                for (int k = 0; k < sheetsName.Rows.Count; k++)//循环sheet
                {
                    string SheetName = sheetsName.Rows[k][2].ToString();
                    string sql = string.Format("SELECT * FROM [{0}]", SheetName); //查询字符串  
                    OleDbDataAdapter ada = new OleDbDataAdapter(sql, StrConn);

                    DataSet set = new DataSet();
                    ada.Fill(set);

                    for (int i = 0; i < set.Tables.Count; i++)
                    {
                        DataTable dt = set.Tables[i];
                        for (int j = 1; j < dt.Rows.Count; j++)
                        {
                            string CouponIds = dt.Rows[j][3].ToString();

                            if (!string.IsNullOrWhiteSpace(CouponIds) && CTX_3U.Common.LC_String.IsNum(CouponIds))
                            {
                                //long CouponId = Convert.ToInt64(CouponIds);
                                int num = EO_CouponBz.Update("HasUserId=" + eA_UserInfo.UserId + " , IssueTime='2019-08-18 16:33:33.333',PI_IssueNum=" + PI_IssueNum + "", "CouponId='" + CouponIds + "'");
                                if (num > 0)
                                {
                                    Console.WriteLine(eA_UserInfo.UserId + eA_UserInfo.TrueName + "HasUserId赋值对应CouponId：" + CouponIds);
                                }
                                else
                                {
                                    Console.WriteLine("无" + CouponIds);
                                }
                            }
                            else if (CouponIds == "")
                            {
                                Console.WriteLine("空" + CouponIds);
                            }
                            else
                            {
                                Console.WriteLine("No" + CouponIds);
                            }

                        }
                    }

                }

                
                Console.Write("执行完毕");
                //Console.ReadKey();
            }
        }
    }