public ActionResult PrintThongKe(int year) { string mgv = Session["UserCode"].ToString(); string role = Session["UserRole"].ToString(); string name = Session["UserName"].ToString(); string fileName = name + "_gio_cong_tac_khac.xlsx"; DataTable data = _statisticSrv.GetDataTableThongkecanhan(mgv, year); if (data == null) { var streamNull = new System.IO.MemoryStream(); ExcelPackage pck = new ExcelPackage(); ExcelWorksheet p = pck.Workbook.Worksheets.Add("Gio Cong Tac Khac"); pck.SaveAs(streamNull); return(File(streamNull.ToArray(), "application/octet-stream", fileName)); } using (ExcelPackage pck = new ExcelPackage()) { ExcelWorksheet workSheet = pck.Workbook.Worksheets.Add("Gio Cong Tac Khac"); FunctionUtility.DataTableToExcelThongKe(workSheet, data, 2018, name, role); var ms = new System.IO.MemoryStream(); pck.SaveAs(ms); return(File(ms.ToArray(), "application/vnd.ms-excel", fileName)); } }