Hi,
Thanks for the reply. Original code are list below.
Actually if I moved the OnGridExporting and OnExcelExportCellFormatting events and only keep onexcelmlexportrowcreated in the aspx. The issue is still the same ---only change the work sheet name but data are gone. So I don't quite understand why this would happen.
Any suggestion is appreciated, thanks in advance!
1. ASPX page:
<div id="divSummaryReport">
<telerik:RadGrid
runat="server"
ID="rgSummaryReport"
AllowPaging="false"
CssClass="GridLines"
AllowSorting="false"
AllowFilteringByColumn="false"
Visible="false"
AllowMultiRowSelection="false"
Enabled="true"
AutoGenerateColumns="false"
OnGridExporting="rgSummaryReport_GridExporting"
OnExcelExportCellFormatting ="rgSummaryReport_ExcelExportCellFormatting"
onexcelmlexportrowcreated="rgSummaryReport_ExcelMLExportRowCreated">
<HeaderStyle HorizontalAlign="Center" Font-Bold="true" />
<ItemStyle HorizontalAlign="Center" />
<exportsettings>
<excel format="ExcelML" />
</exportsettings>
<AlternatingItemStyle HorizontalAlign="Center" />
<MasterTableView>
<Columns>
<telerik:GridBoundColumn DataField="CountyState" HeaderText="County State"></telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="State County Code">
<ItemTemplate>
<div style="mso-number-format:\@;"><%# Eval("CountyCode")%></div>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="CountyDesignation" HeaderText="County Designation"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SpecialtyType" HeaderText="Specialty Type"></telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Specialty Code">
<ItemTemplate>
<div style="mso-number-format:\@;"><%# Eval("SpecialtyCode")%></div>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="Status" HeaderText="Status"></telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</div>
2. CS file:
protected void rgSummaryReport_GridExporting(object source, Telerik.Web.UI.GridExportingArgs e)
{
string title = _reportCriteria.AppIsFinalSubmitted ? " Final-Submission Report" : "Pre-Submission Report";
StringBuilder strHeader = new StringBuilder("<h3><center>" + title + "</center></h3><br>");
strHeader.Append("<h5><b>Contract ID: " + Session["contract_id"] + "<br>");
strHeader.Append("Contract Name: " + Session["contract_name"] + "<br><br>");
strHeader.Append("Report data is valid as of " + lblReportTimestamp.Text + "</b></h5>");
e.ExportOutput = e.ExportOutput.Replace("<head>", "<head><style type=\"text/css\">td {border: 0.1pt solid #000000;}</style>");
e.ExportOutput = e.ExportOutput.Replace("<body>", "<body>" + strHeader.ToString());
e.ExportOutput = e.ExportOutput.Replace("</body>", "Report Downloaded: " + DateTime.Now.ToString() + "</body>");
}
protected void rgSummaryReport_ExcelExportCellFormatting(object source, ExcelExportCellFormattingEventArgs e)
{
e.Cell.Style["text-align"] = "center";
}
protected void rgSummaryReport_ExcelMLExportRowCreated(object sender, GridExportExcelMLRowCreatedArgs e)
{
e.Worksheet.Name = "Name";
}