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());
}
}
