gridview合并行列并导出Excel

最新推荐文章于 2023-03-28 16:39:50 发布

原创最新推荐文章于 2023-03-28 16:39:50 发布 · 545 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#.net c#

.net c# 专栏收录该内容

6 篇文章

订阅专栏

这段代码演示了如何在.NET环境中，利用C#将一个带有合并单元格的GridView导出为Excel文件。通过MergeGridViewCell类合并网格视图的行和列，然后设置响应头以触发文件下载，确保内容类型为Excel应用，并解决数据导出时首字符'0'被过滤的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/// <summary>
/// 导出合并的gridview
/// </summary>
/// <param name="dataSource">数据源</param>
/// <param name="startColoum">要合并起始列，初始值：0</param>
/// <param name="endColoum">要合并的结束列序号</param>
/// <param name="filename">导出的文件名</param>
/// <returns></returns>
public virtual ActionResult ExportMergedGridViewToExcel(object dataSource, int startColoum, int endColoum, string filename = "excel")
{
GridView gv = new GridView();
gv.DataSource = dataSource;
gv.DataBind();
MergeGridViewCell.MergeRow(gv, startColoum, endColoum);
Response.ClearContent();
Response.Clear();
Response.Charset = "UTF8";
Response.ContentEncoding = Encoding.UTF8;

if (Request.Browser.Browser.ToLower() != "firefox")
{
filename = HttpUtility.UrlEncode(Encoding.UTF8.GetBytes(filename));
}
Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".xls"); Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
#region 解决数据第一个字符0导出被过滤掉的问题

string strStyle = "<style>td{mso-number-format:\"\\@\";}</style>";
sw.WriteLine(strStyle);
#endregion
HtmlTextWriter htw = new HtmlTextWriter(sw);
//gv.RenderControl(htw);
//Response.Output.Write("<meta http-equiv=\"content-type\" content=\"application/vnd.ms-excel; charset=utf-8\"/>" + sw.ToString());
if (gv.Rows.Count > 0)
{
gv.RenderControl(htw);
Response.Output.Write("<meta http-equiv=\"content-type\" content=\"application/vnd.ms-excel; charset=utf-8\"/>" + sw.ToString());
}
Response.Flush();
Response.End();

return Content("");
}