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();
}
}
}
处理文件夹下所有excel读取
最新推荐文章于 2023-09-27 19:53:02 发布