public ActionResult ExportExcelEarnedLeaveCreditDetails() { IList <LeaveCreditModel> lstProfile = GetEmployeeELData(); List <LeaveCreditModel> excelData = new List <LeaveCreditModel>(); excelData = lstProfile.ToList(); if (excelData.Count > 0) { string[] columns = { "Emp Id", "Name", "Joining Date", "Confirmation Date", "Existing EL Balance", "EL Credit", "Total EL Balance" }; byte[] filecontent = ExcelExportHelper.ExportExcelELCredit(excelData, "", false, columns); return(File(filecontent, ExcelExportHelper.ExcelContentType, "ELCreditReport_" + System.DateTime.Now + ".xlsx")); } else { ViewBag.ErrorMsg = "Excel file is not generated as no data returned."; return(View("EarnedLeaveCredit")); } }