Gridview To Export Excel sheet
-
Hi, I tried with below code for export gridview to Excell and it is adding empty row for every record . Please suggest me better way to do this. My Code: -------------- response.Clear(); response.ClearContent(); response.Buffer = true; response.ContentType = "application/vnd.ms-excel"; response.Charset = ""; //--code to display multiline value in same cell in excel------------------- string header = @" <!--table br {mso-data-placement:same-cell;} --> "; response.Write(header); response.AddHeader("mso-data-placement", "same-cell"); response.AddHeader("content-disposition", new StringBuilder("attachment; filename=").Append(fileName).Append(".xls").ToString()); } System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); gvControl.RenderControl(oHtmlTextWriter); // response.Write(oStringWriter.ToString().Replace("bordercolor=\"white\"", String.Empty)); response.Write(Regex.Replace(oStringWriter.ToString().Replace("bordercolor=\"white\"", String.Empty).ToString(), @"(]*>)| ()", " ", RegexOptions.IgnoreCase)); response.End(); --------------------------- Regards, Vishnu.
-
Hi, I tried with below code for export gridview to Excell and it is adding empty row for every record . Please suggest me better way to do this. My Code: -------------- response.Clear(); response.ClearContent(); response.Buffer = true; response.ContentType = "application/vnd.ms-excel"; response.Charset = ""; //--code to display multiline value in same cell in excel------------------- string header = @" <!--table br {mso-data-placement:same-cell;} --> "; response.Write(header); response.AddHeader("mso-data-placement", "same-cell"); response.AddHeader("content-disposition", new StringBuilder("attachment; filename=").Append(fileName).Append(".xls").ToString()); } System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); gvControl.RenderControl(oHtmlTextWriter); // response.Write(oStringWriter.ToString().Replace("bordercolor=\"white\"", String.Empty)); response.Write(Regex.Replace(oStringWriter.ToString().Replace("bordercolor=\"white\"", String.Empty).ToString(), @"(]*>)| ()", " ", RegexOptions.IgnoreCase)); response.End(); --------------------------- Regards, Vishnu.
Please Format your Code using "Pre" tag.
-
Hi, I tried with below code for export gridview to Excell and it is adding empty row for every record . Please suggest me better way to do this. My Code: -------------- response.Clear(); response.ClearContent(); response.Buffer = true; response.ContentType = "application/vnd.ms-excel"; response.Charset = ""; //--code to display multiline value in same cell in excel------------------- string header = @" <!--table br {mso-data-placement:same-cell;} --> "; response.Write(header); response.AddHeader("mso-data-placement", "same-cell"); response.AddHeader("content-disposition", new StringBuilder("attachment; filename=").Append(fileName).Append(".xls").ToString()); } System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); gvControl.RenderControl(oHtmlTextWriter); // response.Write(oStringWriter.ToString().Replace("bordercolor=\"white\"", String.Empty)); response.Write(Regex.Replace(oStringWriter.ToString().Replace("bordercolor=\"white\"", String.Empty).ToString(), @"(]*>)| ()", " ", RegexOptions.IgnoreCase)); response.End(); --------------------------- Regards, Vishnu.
All in One Export Data in ASP.NET[^]
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me