将Repeater控件数据导出到Excel或Word

//将控件Repeater中的数据导出到Excel或Word中
//将下列代码放入需要导出数据的.aspx文件对应的.cs文件中
//
 private void Export(String FileType, String FileName)
    {
        Response.Clear();
        Response.BufferOutput = true;
        //设定输出字符集
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.AppendHeader("Content-Disposition", "attachment;filename="
        + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
        //设置输出流HttpMiME类型(导出文件格式)
        Response.ContentType = FileType;
        //关闭ViewState
        Page.EnableViewState = false;
        System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true);
        System.IO.StringWriter stringWriter = new System.IO.StringWriter(cultureInfo);
        HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter);
        //数据源要有边框，否则导出数据也无边框
        Repeater1.RenderControl(textWriter);
        //把HTML写回游览器
        Response.Write(stringWriter.ToString());
        Response.End();
        Response.Flush();
    }

    //确认在运行时为指定的 ASP.NET 服务器控件呈现在 HtmlForm 控件中。
    //(检验Asp.Net服务器控件是否呈现在HTMLForm控件中)
    /*