FormView to Excel - How to pull data from controls in template to place in cells.

Here is the layout, I have a FormView control with dynamic data coming in from a SQL server. I am using the ReadOnly mode of the FormView. How can I tweak the PrepareFormViewForExport method to remove the textboxs and leave the values in the FormView behind? Right now the output is showing labels but leaving out the values from the textboxs. This is the C# code when the export button is clicked. protected void Bexport_Click(object sender, EventArgs e) { //Clear the Response object Response.Clear(); //set Response header to the Excel filename required (.xls for excel, .doc for word) Response.AddHeader("content-disposition", "attachment;filename=ReportOuput.xls"); Response.Charset = ""; // If you want the option to open the Excel // file without the save option then un-comment out the line below //Response.Cache.SetCacheability(HttpCacheability.NoCache); //FOR EXCEL Response.ContentType = "application/vnd.xls"; //FOR WORD //Response.ContentType = "application/vnd.doc"; //Declare new stringwriter and html writer StringWriter stringWrite = new System.IO.StringWriter(); HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); //Strip out controls from FormView ?takes data too? PrepareFormViewForExport(FormView2); //render controls data as HTML FormView2.RenderControl(htmlWrite); //Clean out the Javascript postbacks etc. string html = stringWrite.ToString(); html = Regex.Replace(html, "", ""); StringReader reader = new StringReader(html); //Write xls document Response.Write(html); //end current Response HttpContext.Current.Response.End(); } Here is the method for removing controls from the FormView before rendering it for export. private void PrepareFormViewForExport(Control fv) { LinkButton lb = new LinkButton(); Literal l = new Literal(); string name = String.Empty; TextBox TB = new TextBox(); for (int i = 0; i

以上就是FormView to Excel - How to pull data from controls in template to place in cells.的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏