1.首先,需要指定获取的文件夹,以及获取文件的文件名;
文件夹:strLocalPath = System.Windows.Forms.Application.StartupPath + "\\ExcelTemplate\\";
文件名:temp.xlsx
2.代码:
ExecutionResult result = new ExecutionResult();
result.Status = true;
string strLocalPath = System.Windows.Forms.Application.StartupPath + "\\ExcelTemplate\\";
if (Directory.Exists(strLocalPath))
{
foreach (string GCFile in Directory.GetFiles(strLocalPath, "temp.xlsx", SearchOption.TopDirectoryOnly))
{
string fileName = Path.GetFileName(GCFile);
string filename = Path.GetFileName(GCFile).Replace(".xlsx", "") + DateTime.Now.ToString("_yyyyMMdd") + ".xlsx";
try
{
File.Copy(strLocalPath + fileName, strLocalPath + "Temp\\" + filename, true);
result = GetA31DayData(strLocalPath + "Temp\\" + filename);
}
catch (Exception ex)
{
result.Status = false;
result.Message = "copy file to destination file exception. Msg:" + ex.Message;
result.Anything = ex.Message;
if (mesLog.IsErrorEnabled)
{
mesLog.Error(ex.StackTrace);
}
}
}
}
else
{
result.Status = false;
result.Message = "Directory not exists!";
}
return result;