public static void WriteExcelData(string tempFile, string destinationFile, RecipeTemplates templates, IEnumerable<RecipeVariable> variableList) { try { RecipeMasterServices.WriteNewProductionFile(tempFile); using (IExcelEngine excelEngine = new ExcelEngine(tempFile)) { foreach (RecipeVariable rv in variableList) { excelEngine.WriteCellValue(rv.CellMap, rv.Value); } RecipeMasterServices.RenameExistingFile(destinationFile, false); excelEngine.Save(destinationFile); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { if (File.Exists(tempFile)) { File.Delete(tempFile); } } }
public static void WriteExcelData(string destinationFile, RecipeTemplates templates, IEnumerable<RecipeVariable> variableList) { try { using (IExcelEngine excelEngine = new ExcelEngine(destinationFile)) { foreach (RecipeVariable rv in variableList) { excelEngine.WriteCellValue(rv.CellMap, rv.Value); } excelEngine.Save(destinationFile); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }