xlsx文件异常处理

patrick.xu

2021-02-20 b3aa95bab5796caaf28a06922abf111ae55e37df

xlsx文件异常处理

 src/Bro.M071.Process/M071Process.cs

@@ -835,7 +835,9 @@
                        Directory.CreateDirectory(Config.LogPath);
                    }
                    var fileName = Path.Combine(Config.LogPath, $"LDSData_{DateTime.Now.ToString("yyyyMMdd")}.xlsx");
                    //bool isExisted = File.Exists(fileName);

                    try
                    {
                    using (ExcelPackage package = new ExcelPackage(new FileInfo(fileName)))
                    {
                        ExcelWorksheet rawDataSheet = null;
@@ -1134,6 +1136,14 @@
                        rowAlignmentSheet.Dispose();
                    };
                }
                    catch (Exception ex)
                    {
                        LogAsync(DateTime.Now, "Excel日志异常", ex.GetExceptionMessage());
                        string bkFileName = Path.Combine(Config.LogPath, $"{Path.GetFileNameWithoutExtension(fileName)}_bk_{DateTime.Now.ToString("HHmmss")}.xlsx");
                        File.Copy(fileName, bkFileName);
                        File.Delete(fileName);
                    }
                }
            });
        }