gpt4 book ai didi

header - Telerik 导出到 Excel : Need to add an additional header containing HTML

转载 作者:行者123 更新时间:2023-12-02 06:26:02 24 4
gpt4 key购买 nike

我正在使用以下代码将 Telerik Grid 内容导出到 Excel。代码如下:

grdDisbursementDetail.Page.Response.ClearHeaders();
grdDisbursementDetail.Page.Response.Cache.SetCacheability(HttpCacheability.Private);
grdDisbursementDetail.ExportSettings.ExportOnlyData = true;
grdDisbursementDetail.ExportSettings.IgnorePaging = false;
grdDisbursementDetail.MasterTableView.HierarchyDefaultExpanded = true;
grdDisbursementDetail.ExportSettings.OpenInNewWindow = true;
grdDisbursementDetail.GridLines = GridLines.Both;

//grdDisbursementDetail.PageSize = grdDisbursementDetail.PageCount;
grdDisbursementDetail.ExportSettings.FileName = Common.GetLiteral("Report_DisbursementDetailReport_PDFExportFileName");

//grdDisbursementDetail.MasterTableView.Columns[0].Visible = false;

// grdDisbursementDetail.MasterTableView.DataSource = grdDisbursementDetail.Items;
grdDisbursementDetail.MasterTableView.ExportToExcel();

grdDisbursementDetail 是一个Telerik RadGrid。我想在 Excel 的标题中添加 HTML。如果有办法添加标题,请告诉我。

最佳答案

您需要真正的页眉还是只需要工作表开头的一些自定义文本?

工作表开头的自定义文本:

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
if (e.ExportType == ExportType.Excel)
{
string customText = "your text goes here";
e.ExportOutput = e.ExportOutput.Replace("<body>", "<body>" + customText);
}
}

页眉中的自定义文本:

protected void RadGrid1_HTMLExporting(object sender, GridHTMLExportingEventArgs e)
{
string headerText = "My header text";
string css = String.Format("table @page {{ mso-header-data:\"{0}\"; }}", headerText);
e.Styles.Append(css);
}

祝你好运

关于header - Telerik 导出到 Excel : Need to add an additional header containing HTML,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/9258185/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com