[Solved] Alternating item Style in Excel - exported from Telerik Grid

[A2H]

Hi,

I have a Telerik Rad Grid and it has Export to excel functionality implemented in it .I am able to export to excel witt out any formatting options.

Now I want to add formatting into excel sheet which is being exported.

I am using telerik rad grid built in method to apply the formatting in Excel.
ie : ExcelMLExportStylesCreated , ExcelMLExportRowCreated

with this method I am unable set the background color to alternating item in excel file.

I want to give back ground color to alternating rows in excel sheet.

Attached image is the result i wanted

Please help me

Thanks,
A2H

[Shinu]

Hi,

You can set alternatingitemstyle as explained in the following documentation.
ExcelML basics

Thanks,
Shinu

[A2H]

Hi Shinu,

Thanks for your reply.

This doesn't answers my question.I am able to define styles with in the method "ExcelMLExportStylesCreated".

But unfortunately I am not getting how to assign this color to rows in Excel.

Thanks,
A2H

[A2H]

Hi,

I got the desired result. 

I had followed the link given below and it gives a clear picture on how to export Excel file from Telerik Rad Grid.

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/excelmlexport/defaultcs.aspx

Thanks,
A2H