public void ExcelFile() { Models.formDataModel fdData = new Models.formDataModel(); List <Models.formFieldsModel> LstData; excelDataList = new List <Models.formFieldsModel>(); LstData = fdData.callJotFormAPI(); for (int i = 0; i < LstData.Count; i++) { Models.formFieldsModel formFields = new Models.formFieldsModel(); formFields.custId = Int32.Parse(LstData[i].custId.ToString()); formFields.firstName = LstData[i].firstName; formFields.lastName = LstData[i].lastName; formFields.country = LstData[i].country; formFields.email = LstData[i].email; formFields.favProduct = LstData[i].favProduct; excelDataList.Add(formFields); } ExcelPackage excel = new ExcelPackage(); var workSheet = excel.Workbook.Worksheets.Add("Sheet1"); workSheet.Cells[1, 1].LoadFromCollection(excelDataList, true); using (var rng = workSheet.Cells["A1:AE" + excelDataList.Count + 1]) { rng.AutoFitColumns(); } using (var memoryStream = new MemoryStream()) { Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=" + "ExcelReport _" + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Year + ".xlsx"); excel.SaveAs(memoryStream); memoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } }
public ActionResult Index() { Models.formDataModel fdObj = new Models.formDataModel(); fdObj.callJotFormAPI(); return(View("Index", fdObj)); }