Export DataTable to Excel sheet

Question

I am written code to export datatable to excel sheet but the error is "The name 'Response' does not exist in the current context." How to solve this? Thanks in advance.

Brajesh Kumar · Answer

Hi Shaik It will be much easier to answer if tyou share the code .and where you get errors Although let me try to give you the solution .Hope it work Try using System.Web.HttpContext.Current.Response using System.IO; using System.Data; using ClosedXML.Excel; using System.Configuration; using System.Data.SqlClient; or you can visit following link https://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/ https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-export-datatable-to-excel/501 https://www.aspsnippets.com/Articles/Export-DataTable-to-Excel-in-ASPNet-using-C-and-VBNet.aspx use this code as fun to export your data... dt = city.GetAllCity(); //data filled from your service or fun//your datatable string attachment = "attachment; filename=city.xls" ; Response.ClearContent(); Response.AddHeader( "content-disposition" , attachment); Response.ContentType = "application/vnd.ms-excel" ; string tab = "" ; foreach (DataColumn dc in dt.Columns) { Response.Write(tab + dc.ColumnName); tab = "	" ; } Response.Write( "
" ); int i; foreach (DataRow dr in dt.Rows) { tab = "" ; for (i = 0; i { Response.Write(tab + dr[i].ToString()); tab = "	" ; } Response.Write( "
" ); } Response.End();

Leon D · Answer

Export data table to excel/excel to data table is very easy with free spire.xls library. You can get free spire.xls library from NuGet and refer to the following article: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

Shaik Vahid · Answer

I missed CODEXML namespace. Now i added dll to project and it's working. Thanks for your reply.

Raghavendar Swaminathan · Answer

Hi Shaik, Please show the error which VS is throwing. Thanks Raghav