Asp.Net页面输出到EXCEL,下面代码不能调用excel,请大家看看,请教

Question

Response.Clear()
        Response.Buffer = True
        Response.Charset = "utf-8"
        Response.AppendHeader("Content-Disposition", "inline;filename=FileFlow.xls")
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8")
        Response.ContentType = "Application/vnd.ms-excel"
        Me.EnableViewState = False
        Dim oStringWriter As New System.IO.StringWriter
        Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)
        Me.RenderControl(oHtmlTextWriter)
        Response.Write(oStringWriter.ToString())
        Response.End()

Answer 1

....
        Response.AddHeader("Content-Disposition", "attachment; filename=" + sFileName);
        Response.ContentType = "application/ms-excel";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        //generate excel and close the httpresponse
        Response.Write(sw);
        Response.End();
sw（StringWriter）里面同一行用\t分隔