输出流导出Excel的方法和asp.net过滤html,急!!!!!!!!!!!!!!!

[angellan]

输出流导出Excel的方法和asp.net过滤html
private void Export(string FileType, string FileName)
{
Response.Charset = "GB2312";
//Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("name","hao");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
DataTable dt = new DataTable();
dt = NewMethod();
this.GridView1.RenderControl(hw);//这里如何换成dataTable

Response.Write(NoHTML(tw.ToString()));
Response.End();

}

[shulei521]

[Quote=引用 3 楼 lovehongyun 的回复:]
可以借助DataGrid或GridView的RenderControl方法输出


C# codeprivate void Export(string FileType, string FileName)
{
GridView gv= new GridView();
DataTable dt = NewMethod();
this.gv.DataSource = dt;
this.gv.DataBind();

Response.Charset = "GB2312";
//Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHe…
[/Quote]
楼上的 是男是女呢

[onionandbaobao]

最好以gridview的形式导出来，比较清楚

[yegreen]

你是先读出来,然后再写入, 推荐你边读边写, 速度提高不知道多少倍.

[wihtsky]

            DataTable dt = new DataTable();
            dt.Columns.Add("你需要的列");
            dt.Columns.Add("你需要的列");
            dt.Columns.Add("你需要的列");
            dt.Columns.Add("你需要的列");
            //循环遍历 添加
            for (int i = 0; i < 给出条件; i++)
            {
                DataRow drow = dtContent.NewRow();
                drow["你上面填写的列"] = 赋值;
                drow["你上面填写的列"] = 赋值;
                drow["你上面填写的列"] = 赋值;
                drow["你上面填写的列"] = 赋值;
                dtContent.Rows.Add(drow);
            }

[wolfsky1994]

TempContent = System.Text.RegularExpressions.Regex.Replace(TempContent,"<[^>]*>","");

[lovehongyun]

可以借助DataGrid或GridView的RenderControl方法输出

private void Export(string FileType, string FileName) 
    { 
        GridView gv= new GridView();
        DataTable dt = NewMethod(); 
        this.gv.DataSource = dt;
        this.gv.DataBind();

        Response.Charset = "GB2312"; 
        //Response.ContentEncoding = System.Text.Encoding.UTF8; 
        Response.AppendHeader("name","hao"); 
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); 
        Response.ContentType = FileType; 
        this.EnableViewState = false; 
        System.IO.StringWriter tw = new System.IO.StringWriter(); 
        HtmlTextWriter hw = new HtmlTextWriter(tw); 
        gv.RenderControl(hw);//这里如何换成dataTable 

        Response.Write(NoHTML(tw.ToString())); 
        Response.End(); 

    }

[zincy]

mark