/// <summary>
/// Exports the excel event handler.
/// </summary>
public void ExportExcelEventHandler(ExportExcelResult dt)
{
try
{
var workbook = new XLWorkbook();
IXLWorksheet worksheet = workbook.Worksheets.Add("outputfile");
//worksheet.Cell(1, 1).Value = "Id";
worksheet.Cell(1, 1).Value = "LastName";
worksheet.Cell(1, 2).Value = "FirstMidName";
worksheet.Cell(1, 3).Value = "EnrollmentDate";
for (int index = 1; index <= dt.ExportData.Count; index++)
{
//worksheet.Cell(index + 1, 1).Value = dt.ExportData[index - 1].ID;
worksheet.Cell(index + 1, 1).Value = dt.ExportData[index - 1].LastName;
worksheet.Cell(index + 1, 2).Value = dt.ExportData[index - 1].FirstMidName;
worksheet.Cell(index + 1, 3).Value = dt.ExportData[index - 1].EnrollmentDate;
}
//using (var stream = new MemoryStream())
//{
// workbook.SaveAs(stream);
// var content = stream.ToArray();
// return File(content, contentType, fileName);
//}
//workbook.SaveAs(@"C:\Users\v-ivowan\Desktop\" + dt.FileName);
}
catch (Exception ex)
{
throw(ex);
}
}
/// <summary>
/// 檢查匯入的 Excel 資料.
/// </summary>
public void ExecuteResult(ExportExcelResult dt)
{
if (dt.ExportData == null)
{
throw new InvalidDataException("ExportData");
}
if (string.IsNullOrWhiteSpace(dt.SheetName))
{
this.SheetName = "outputfile";
}
if (string.IsNullOrWhiteSpace(dt.FileName))
{
this.FileName = string.Concat(
"ExportData_",
DateTime.Now.ToString("yyyyMMddHHmmss"),
".xlsx");
}
this.ExportExcelEventHandler(dt);
}