How Export data into excel in mvc4 directly ?

Question

I want to export data directly in mvc4 to excel but my Nuget package ClosedXML not found here.. What's the problem here ? Thanks in Advance Nazmul

Ramesh Palanivel · Answer

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/

Ankit Sharma · Answer

Hi Nazmul, You need to install Closedxml using nuget. Visit this link to see how to install packages using Nuget package manager http://www.c-sharpcorner.com/UploadFile/8a67c0/use-nuget-package-manager-in-visual-studio-2015/ Use nuget command : Install-Package ClosedXML -Version 0.88.0 and include using ClosedXML.Excel; in your .cs file Hope this helps

How Export data into excel in mvc4 directly ?

Answers (2)