1.首先,需要指定获取的文件夹,以及获取文件的文件名; 文件夹:strLocalPath = System.Windows.Forms.Application.StartupPath + \\ExcelTemplate\\; 文件名:temp.xlsx 2.代码: ExecutionResult result = new Executio
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;
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持自由互联。