Make an Application

Question

Export web page contents to excel file.

Sanjeeb Lenka · Answer

hi refer to this link http://www.c-sharpcorner.com/Blogs/12486/export-gridview-data-to-excel-word-pdf-text-and-csv-forma.aspx

Ravi Shekhar · Answer

try this public void ExportData(DataTable dset) { HttpResponse response = HttpContext.Current.Response; // first let's clean up the response.object response.Clear(); response.Charset =  ; // set the response mime type for excel //Dim filename As String = Record.xls string filename = Report( +  + DateTime.Now.ToString( dd-MM-yyyy ) + ).xls ; response.ContentType = application/vnd.ms-excel ; response.AddHeader( Content-Disposition  attachment;filename=\ + filename + \ ); // create a string writer using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // instantiate a datagrid DataGrid dg = new DataGrid(); dg.DataSource = dset; dg.DataBind(); dg.RenderControl(htw); response.Write(sw.ToString()); response.End(); } } }