将自定义标题添加到 excel 文件 [英] Adding Custom header to the excel file

问题描述

在 ASP.NET 中将 DataSet 导出到 Excel 时，是否可以向 Excel 添加自定义标题?我有一个这样的要求.我可以成功地将 DataSet 导出到 Excel.但我无法添加自定义标题.如果有人有解决方案，请帮助我.提前致谢.

Is it possible to add a custom header to the Excel while exporting a DataSet to Excel in ASP.NET? I have one requirement like this. I can export the DataSet to the Excel successfully. But I can't add the custom header. Please help me if anybody have the solution. Thanks in advance.

推荐答案

如果您使用 Response.Write 导出 Excel.您可以毫不费力地使用以下代码，并且可以根据需要自定义 Header，就像 HTML 标头一样.

IF you are using Response.Write to Export the Excel. You can use the following code with minimal effort and the Header can be customized as you want, just like HTML headers.

Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls;");                
StringWriter stringWrite = new StringWriter();        
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);        
dgrExport.DataSource = dtExport;        
dgrExport.DataBind();
dgrExport.RenderControl(htmlWrite);
string headerTable = @"<Table><tr><td>Report Header</td></tr><tr><td><img src=""D:\Folder\Report Header.jpg"" ></td></tr></Table>";
Response.Write(headerTable);
Response.Write(stringWrite.ToString());        
Response.End();

Mac，你也在寻找同样的东西吗?

Mac, Are you looking for the same?

这篇关于将自定义标题添加到 excel 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！