private void GenerateReport(Excel.Workbook workbook, SheetItems sheetItems)
{
Excel.Worksheet worksheet = workbook.Worksheets.get_Item(1) as Excel.Worksheet;
var cell_recommandDate = worksheet.Cells.Find("$RecommandNextClaibDate");
if (cell_recommandDate != null)
{
cell_recommandDate.Value = sheetItems.RecommandNextCalibDate;
}
BulkInsertRow(sheetItems.ItemsList[0], "$DataArea", worksheet);
BulkInsertRow(sheetItems.ItemsList[1], "$DataArea2", worksheet);
ReleaseObject(ref worksheet);
}
public void CreateExcel(string templateFileName, string savePath, SheetItems items)
{
Excel.Application excel = null;
Excel.Workbook workbook = null;
try
{
excel = new Excel.Application();
workbook = excel.Workbooks.Open(Application.StartupPath + "\\ReportTemplate\\" + templateFileName);
GenerateReport(workbook, items);
workbook.SaveAs(savePath);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
workbook.Close(false);
ReleaseObject(ref workbook);
excel.Quit();
ReleaseObject(ref excel);
}
}
