C# REST API to download excel sheet by EPPlus. Working code. From data table

C# REST API to download excel sheet by EPPlus. Working code. From data table.

[HttpGet]

        public string TestExcel()

        {

            DataTable table = new DataTable();

            table.Columns.Add("Dosage", typeof(int));

            table.Columns.Add("Drug", typeof(string));

            table.Columns.Add("Patient", typeof(string));

            table.Columns.Add("Date", typeof(DateTime));

            // Step 3: here we add 5 rows.

            table.Rows.Add(25, "Indocin", "David", DateTime.Now);

            table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);

            table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);

            table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);

            table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);

            using (ExcelPackage p = new ExcelPackage())

            {

                ExcelWorksheet ws1 = p.Workbook.Worksheets.Add("RSL Master");

                ws1.Cells["A1"].LoadFromDataTable(table, true, OfficeOpenXml.Table.TableStyles.None);

                Byte[] bin = p.GetAsByteArray();

                System.Web.HttpContext.Current.Response.Clear();

                System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=RSL_Master.xlsx");

                System.Web.HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

                System.Web.HttpContext.Current.Response.BinaryWrite(bin);

                System.Web.HttpContext.Current.Response.End();

            }

            return "success";

        }