How Export data into excel in mvc4 directly ?

Hi Nazmul,

 

If you want to export data from mvc to excel, you achieve this following way,

 

1. You need excel object for exporting data to excel from mvc. Install ms excel in you machine , using excel object you can achieve that.

 please refer the link for exporting to excel,

 

http://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/ 

 

2.If you don't want to install excel on your machine, you have lot third pary open source dll availabel in nuger. Ex : Exceldatareader,splir.xls(paid service), etc. 

 

please refer the below link 

 

https://exceldatareader.codeplex.com/ 

 

You need to install Closedxml using nuget.

 

 

Hope this helps