Below code is helpful for exporting data to excel
public FileResult ExporttoExcel_Points(SearchCriteria formData) { MemoryStream output = ExportFunction_AvailablePoints(formData); return File(output.ToArray(), //The binary data of the XLS file "application/vnd.ms-excel", //MIME type of Excel files "AvailablePoints.xls"); } // Search criteria is optional public MemoryStream ExportFunction_Points(SearchCriteria search) { // Here we are fetching data using Entity framework Listdata = new List (); ReportsRepository repository = new ReportsRepository(); data = repository.GetAvailablePoints(search.AccountNo, search.Name); MemoryStream output = new MemoryStream(); StreamWriter writer = new StreamWriter(output, Encoding.UTF8); // The column name shown in the excel file writer.Write("Account Number"); writer.Write(","); writer.Write("Name"); writer.Write(","); writer.WriteLine(); int Count = 0; foreach (prcGetAvailablePoints_Result re in data) { writer.Write(re.Account); writer.Write(","); writer.Write(re.Name); writer.Write(","); writer.WriteLine(); Count++; } writer.Flush(); output.Position = 0; return output; }
No comments:
Post a Comment