[Solved] Styling Excel Export

[Arya]

Hi,
 
I have a very complicated business logic by which I color each cell in a RadGridView.
This color logic is implemented in a web service.
In the final data source, each data cell comes with its own color based on this logic and a cell level style selector assigns each cell with its appropriate color.

I want to export to excel and retain that coloring. Is it possible?

void theDataGrid_Exporting(object sender, GridViewExportEventArgs e)
{
    if (e.Element == ExportElement.Cell)
    {
        e.background = ??
    }
}

Thanks
Arya

[Vlad]

Hello Arya,

 I strongly suggest you to check our demos.

Regards,
Vlad
the Telerik team

[Anne Lyon]

Hello,
picking up this old post as I haven't found an answer to my problem which is similar to the one above: I want to export a grid where each cell potentially can have a different background color. In Grid_Exporting I need to check the background color of each Export Element of type Cell and set the Style based on the Background. I can do this if the whole column has a backGround but not if I need to look in each cell.
In Your demo you set individual colors/styles based on e.Value (which is easy to find) or e.Context's UniqueName (all values on column Level are easy to find), but how can I check which Style to set based on background in a cell? e.Background is always null, and I understand it is obsolete anyway.
Do you have any suggestion? Originally I set the cellBackground by binding the CellStyle property for the Column, but if there are other ways of setting individual cell backgrounds in the GridView which makes the background detectable while exporting I am happy to change my code.
Thanks for any input.

[Dimitrina]

Hi,

As it turns out, currently this is all the information available with the GridViewElementExportingEventArgs and there is not a better approach to suggest when exporting via the Export method. I can also suggest you checking the alternative approach illustrated in our "SpreadProcessing Integration" WPF Demo.

Regards,
Dimitrina
Telerik