the databse table data export to excel in asp.netmvc

Question

i have one table data in my database .the table data export into excel plz help me

Neboja · Answer

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 .

darjeam nh · Answer

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

Lakshmanan Sethu · Answer

Hi Padma Please refer the link http://mvc4beginner.com/Sample-Code/ImportExportExcelData/MVC4-Export-Data-to-Excel.html