GridView 导出Excel 为文本格式

 

 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的同样适用