GridView 导出Excel 为文本格式

最新推荐文章于 2022-02-11 16:13:33 发布

w87875251l

最新推荐文章于 2022-02-11 16:13:33 发布

阅读量1.7k

点赞数 1

分类专栏： .net 文章标签： excel string

本文链接：https://blog.csdn.net/w87875251l/article/details/6795691

版权

.net 专栏收录该内容

56 篇文章 0 订阅

订阅专栏

private void ExportGridView(string FileType,string FileName)
    {
        for (int i = 1; i <= GridView1.Rows.Count;i++ )
        {
           GridView1.Rows[i - 1].Cells[9].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
            // GridView1.Rows[i - 1].Cells[10].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
           // GridView1.Rows[i - 1].Cells[11].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
        }

        Response.ClearContent();
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.AppendHeader("Content-Disposition", "attachment;filename="+HttpUtility.UrlEncode(FileName,System.Text.Encoding.UTF8));
        Response.ContentType = FileType;
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
       this.GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
    }

for (int i = 1; i <= GridView1.Rows.Count;i++ )
        {
           GridView1.Rows[i - 1].Cells[9].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
            // GridView1.Rows[i - 1].Cells[10].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
           // GridView1.Rows[i - 1].Cells[11].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
        }

Cell[9]为Excel中第十列 Excel 中从0开始, 对身份证信息很有用列的内容开头是0的同样适用