错误将treeview导出到excel文件 [英] error export treeview to excel file

问题描述

我正在尝试将树视图导出到excel文件，但是我得到的是错误消息:

I am trying to export tree view to excel file but i get this is error:

/******************************Error Message*****************************
RegisterForEventValidation can only be called during Render();
*****************************Export Code*******************************/
private void ExportTree()
    {
        
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("content-disposition","attachment;filename="+Ddl_Companies.SelectedItem.Text +"----"+ Ddl_TreeType.SelectedItem.Text+".xls");
        Response.Charset = "";
        //this.EnableViewState = false;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        TreeNode tn=new TreeNode(Ddl_Companies.SelectedItem.Text +"----"+ Ddl_TreeType.SelectedItem.Text,"-1");
        Tv_Tree.Nodes.AddAt(0, tn);
        Tv_Tree.ExpandAll();
        Tv_Tree.ShowExpandCollapse = false;

        HtmlForm frm = new HtmlForm();
        Tv_Tree.Parent.Controls.Add(frm);
        frm.Attributes.Add("runat", "server");
        frm.Controls.Add(Tv_Tree);

        frm.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();
    }

推荐答案

您好，这是一个类似的讨论:请查看: ^ ].

另一种方法是研究导出到excel:将数据导出到Excel [ ^ ]

Hi, this is a similar discussion: please have a view: http://forums.asp.net/t/1222903.aspx[^].

An alternative is a research on export to excel: Exporting Data to Excel[^]

这篇关于错误将treeview导出到excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！