c# - 在将 gridview 导出到 excel 时包含空格

Question

我正在尝试将 Gridview 导出到 Excel 文件。

示例 SQL 数据库记录

91091234 SAM PLE TEXT
89237416 SAMPLE TEXT

我已经能够将它绑定到 Gridview，包括多个空格。我已经使用此代码来包含这些多个空格

protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
{
   foreach (TableCell cell in e.Row.Cells)
   {
      cell.Text = cell.Text.Replace(" ", "&nbsp"); // need to modify this part, i think
   }
}

我将 Gridview 导出到 Excel 的代码

private void _exportGV()
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = "Instances" + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
gv.GridLines = GridLines.Both;
gv.HeaderStyle.Font.Bold = true;
gv.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}

所以我的问题是当我像这样导出数据时

91091234 SAM&nbspPLE&nbspTEXT
89237416 SAMPLE&nbspTEXT

如何保留多个空格而不将其替换为  ？

标签： c#asp.netexcelgridview