the databse table data export to excel in asp.netmvc

Hi, here is a straightforward solution for exporting a DataTable object into an Excel workbook with C#:

var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add(myDataTable.TableName);

worksheet.InsertDataTable(myDataTable, new InsertDataTableOptions("A1") { ColumnHeaders = true });
// Stream an new excel file from MVC controller to the client's browser.
workbook.Save(this.Response, "DataTable.xlsx");

This API comes from a .NET library which processes an Excel type workbooks.

refer:
http://www.codeproject.com/Tips/750246/Export-Data-from-Database-Table-to-Excel-File-in-A
http://www.c-sharpcorner.com/UploadFile/9c6206/export-data-from-database-table-to-excel-file-in-Asp-Net-mvc/
http://www.e-iceblue.com/Knowledgebase/Spire.DataExport/Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html

hope one of them gives you a solution.
regards

Hi Padma

Please refer the link

http://mvc4beginner.com/Sample-Code/ImportExportExcelData/MVC4-Export-Data-to-Excel.html