Saturday, 22 September 2012

Export Grid to Excel using MVC 3


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
List data = 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