protected void DownloadTemplate_Click(object sender, DirectEventArgs e) { try { var serverPath = Server.MapPath("../../../File/Template/importTimeSheetCodeTemplate.xlsx"); DataTable dataTable = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ExcelTimeSheetCode(null)); WorkBook workBook = new WorkBook(); workBook.ImportDataTable(dataTable, true, 0, 0, dataTable.Rows.Count + 1, dataTable.Columns.Count + 1); workBook.writeXLSX(serverPath); Response.AddHeader("Content-Disposition", "attachment; filename=" + "importTimeSheetCodeTemplate.xlsx"); if (serverPath != null) { Response.WriteFile(serverPath); } Response.End(); } catch (Exception ex) { ExtNet.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show(); } }