GridView 导出为Excel

/// <summary>    /// GridView数据导出到Excel表    /// </summary>    /// <param name="ctl">DataGrid控件</param>    /// <param name="fileName">文件名</param>    /// <param name="style">样式</param>    protected void DGToExcel(Control ctl, string fileName, string style)    {        StringBuilder sbStyle = new StringBuilder();

        switch (style)        {            case "text":                sbStyle.Append(@"<style> .text { mso-number-format:/@; } </script> ");                break;            case "General":                sbStyle.Append(@"<style> .General { mso-number-format:General; } </script> ");                break;            default:                sbStyle.Append(@"");                break;        }

        fileName = fileName + DateTime.Now.ToString("yyyyMMddHHmmss");

        Response.Clear();        Response.Buffer = true;        Response.Charset = "GB2312";        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlPathEncode(fileName) + ".xls");

                     Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");        //Response.ContentEncoding = System.Text.Encoding.Default;

        //设置输出文件类型为excel文件。        Response.ContentType = "application/ms-excel";        Response.Cache.SetCacheability(HttpCacheability.Private);

        StringWriter oStringWriter = new StringWriter();

        HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);        ctl.RenderControl(oHtmlTextWriter);

        if (sbStyle.ToString().Trim() != "") Response.Output.Write(sbStyle);

        Response.Output.Write(oStringWriter.ToString());

        Response.Flush();        Response.End();    }

Question：

如果直接导出，可能将原来一些GridView中String类型的数据强制转换成int类型（例：0001解析为1）

解决方法：

这个问题可以通过把css添加到输出流中来解决。为了使ID列正确显示，您需要将其储存为文本格式。Excel中的文本格式表示为"mso-number-format:"/@"，将要导出的GridView相应列的class属性设置为text。

 STEP 1：

protected void grid_ItemDataBoundForExport(object sender, DataGridItemEventArgs e)    {        if (e.Item.ItemIndex > -1)        {

           //通过”style”变量来控制GridView列的样式。            e.Item.Cells[1].Attributes.Add("class", "text");         }    }

STEP 2：

 DGToExcel(ctl,fileName,"text");