微信扫一扫联系
 
.net中导出excel时不能自动显示网格线的解决方案
发布:2020/11/25 17:04:00
protected void btnExport_Click(object sender, EventArgs e)
    {
        MemoryStream stream = new MemoryStream();
        this.OlapGrid1.Export(stream);
        StreamReader streamReader = new System.IO.StreamReader(stream);
        stream.Position = 0;
        string data = streamReader.ReadToEnd();
        Response.Clear();
        Response.Charset = "UTF-8";
        Response.ContentEncoding = System.Text.Encoding.Default;
        // 添加头信息,为"文件下载/另存为"对话框指定默认文件名
        Response.AddHeader("Content-Disposition", "attachment; filename=Model.xls");
        // 添加头信息,指定文件大小,让浏览器能够显示下载进度
        Response.AddHeader("Content-Length", data.Length.ToString());
        // 指定返回的是一个不能被客户端读取的流,必须被下载
        Response.ContentType = "application/ms-excel";
        Response.Write("");
        Response.Write(AddExcelHead()); //显示网格线
        Response.Write(data);//导出数据
        Response.Write(AddExcelbottom());//显示网格线
        Response.Flush();
        Response.End();
    }

    public static string AddExcelHead()
    {
        System.Text.StringBuilder sb = new System.Text.StringBuilder();
        sb.Append("");
        sb.Append(" ");
        sb.Append(" ");
        sb.Append(" ");
        sb.Append("");
        return sb.ToString();

    }


    public static string AddExcelbottom()
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("");
        sb.Append("");
        return sb.ToString();
    }