Write data to excel template in MVC

See more:

Javascript

HTML

MS-Excel

MVC5

Hi

I need some guidance on how export data i gather from my model and export this to excel, without displaying it on my view. Basically i have a date to and from and when the user click on submit, i want to go fetch the data and bring it back to pre defined excel template

i am new to MVC and any guidance on this would be much appreciate

What I have tried:

Ok so i am using closexml, i have the data writing to excel ok, now my only query that i have now, i want to write the same data to a template that i have created, instead of writing to a blank template each time, can this be achieved?

public ActionResult ExportToExcel(string datepicker, string datepicker1)
       {
           List<Checks_Records> getCheckRecords;

           var startDate = DateTime.Parse(datepicker).AddHours(7);
           var endDate = DateTime.Parse(datepicker1).AddHours(7);

           getCheckRecords = CheckRecords.GetListofRecordsForExcelReport(startDate, endDate);

           var gv = new GridView();
           gv.DataSource = getCheckRecords;
           gv.DataBind();
           Response.ClearContent();
           Response.Buffer = true;
           Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls");
           Response.ContentType = "application/ms-excel";
           Response.Charset = "";
           var objStringWriter = new StringWriter();
           var objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
           gv.RenderControl(objHtmlTextWriter);
           Response.Output.Write(objStringWriter.ToString());
           Response.Flush();
           Response.End();

           return View("Report");
       }