public void ExportCpat(TakeRateParameters parameters) { var business = new TakeRateBusiness(DataContext, parameters, false); var exportData = business.ExportCpat(); var fileName = string.Format("TakeRateCpatExport_{0:yyyyMMdd}_{1}.xlsx", DateTime.Now, parameters.TakeRateId); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=" + fileName); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; using (var stream = new MemoryStream()) { exportData.SaveAs(stream); stream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } }