GridView 导出为Excel

来源：互联网发布：java swing html布局编辑：程序博客网时间：2024/05/21 10:57

/// <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");