MVC Project :Datat Table value down load in Excel.

Question

Hello How can down load data table value in Excel using mvc project (.net frame work 4.5.2) Its not using ClosedXML DLL current project. Can you please help http://my.jetscreenshot.com/demo/20171227-4yay-33kb

Lisa White · Answer

You can search Free Spire.XLS dll and use the following code to easily export data table value to Excel: Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; sheet.InsertDataTable(datatable true  1 1); book.SaveToFile( insertTableToExcel.xlsx ExcelVersion.Version2013);