public ActionResult ExportAttendanceToExcel(EmployeeAttendanceQueryModel EmployeeAttendanceQueryModelObj, string RequestLevelPerson) { List <EmployeeAttendanceModel> excelData = GetEmployeeAttendanceList(EmployeeAttendanceQueryModelObj.UserID.ToString(), (EmployeeAttendanceQueryModelObj.FromDate == DateTime.MinValue ? "" : EmployeeAttendanceQueryModelObj.FromDate.ToString()), (EmployeeAttendanceQueryModelObj.ToDate == DateTime.MinValue ? "" : EmployeeAttendanceQueryModelObj.ToDate.ToString()), RequestLevelPerson, EmployeeAttendanceQueryModelObj.DirectEmployees, true).ToList(); if (excelData.Count > 0) { List <string> columns = new List <string>() { "AttendanceDate", "InOutTime", "InOut", "Name", "BreakDuration" }; // string fileName = "Attendance.xlsx"; string fileName = string.Format("Attendance_{0}{1}", DateTime.Now.ToString("ddMMyyyyHHmmss"), ".xlsx"); if (EmployeeAttendanceQueryModelObj.RequestLevelPerson == "My") { columns = new List <string>() { "AttendanceDate", "InOutTime", "InOut", "BreakDuration" }; } byte[] filecontent = ExcelExportHelper.ExportExcelAttendance(excelData, "", false, columns.ToArray()); return(File(filecontent, ExcelExportHelper.ExcelContentType, fileName)); } else { ViewBag.RequestLevelPerson = RequestLevelPerson; EmployeeAttendanceQueryModel data = new EmployeeAttendanceQueryModel { ErrorMsg = "Excel file is not generated as no data returned." }; return(View("~/Views/Attendance/MyAttendance.cshtml", data)); } }