Problem with ExcelExporting

[Nataly]

Hello, telerik!

I have some problem, connected with this grid. An event "ExcelExportCellFormatting" isn't raised when the grid is in process of exporting to excel.How can i call this event other way?

[Shinu]

Hi,

OnExcelExportCellFormatting event is raised when RadGrid is exported to Excel (before the resulting document is rendered on the client). I am not sure what is happening on your end. Can you confirm that you have added the event handler for the OnExcelExportCellFormatting event in the RadGrid.

ASPX:

 <telerik:RadGrid ID="RadGrid1" Width="800px" runat="server" Skin="Default" AllowMultiRowEdit="true" DataSourceID="SqlDataSource1"
OnExcelExportCellFormatting="RadGrid1_ExcelExportCellFormatting"  >

Thanks
Shinu

[Nataly]

Yes, I do it. And I fill my grid not through SqlDataSource, but in C# code in Page_Load. 

RadGrid1.DataSource = GetSummaryContracts();
RadGrid1.DataBind();

There is a button on the page. 

protected void Button1_Click(object sender, System.EventArgs e)
{
     RadGrid1.MasterTableView.ExportToExcel();
}  

I want to format a view of my grid in Excel through OnExcelExportCellFormatting. But this event isn't raised. I use RadControls_for_ASP.NET_2008_3_1105_source. I will be pleased any help 

[Shinu]

Hi,

I am not sure what is happening on your end. I am using RadControls for asp.net AJAX(2009.1.311.20). Try upgrading to the latest version and see whether it  helps.
Updating RadControls for ASP.NET to another version or license

Thanks
Shinu

[Nataly]

Example

Can you see my example, please. I have updated a version of telerik-controls, but unfortunatly the event ExcelExportCellFormatting will be not raised, if you click ImageButton1

[Nataly]

Thank you!!! I'v already solved my problem!

[Jon Chan]

Hi,

I was wondering if you could let me know how you fixed your problem.  My event is not being raised either.  My telerik controls are updated, and it is also being called.

Thanks.

[Nataly]

Hello, I've added RadAjaxManager and it is working now. 

[Michael Pappas]

It seems that the ExcelExportCellFormatting event handler is only fired when the Excel Export format is set to GridExcelExportFormat.HTML.  ExcelMLdoes not cause the event to fire.

[Daniel]

Hello Michael,

ExcelMLRowCreated and ExcelMLStylesCreated fire when using the ExcelML export. ExcelExportCellFormatting fires when the format is HTML Excel.

For more information:
Word/Excel export (HTML-based) help topic
ExcelML export help topic

Best regards,
Daniel
the Telerik team