We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Virtual Grid & XLSIO

Thread ID:





91335 Nov 12,2009 12:15 PM Nov 21,2009 05:25 AM WPF 3
Tags: GridControl
Puthirak OM
Asked On November 12, 2009 12:15 PM


I've modified your VirtualGrid demo to generate an Excel file.
The style of the cells are not exported.

Is it normal ? Is there a way to resolve this behavior?
I've join the modified project.

I'm using Syncfusion Essential Studio

Reportive SA


Ganesan K [Syncfusion]
Replied On November 13, 2009 04:14 AM

Hi Puthirak,

In the sample, since the background style has been set in the PrepareRenderCell, the value will be available only after the rendering of cell.

If you want the style information to be exported, then you need to give the style information in the QueryCellInfo.

We have made this setting in your sample and attached it in the following location.


Please let us know if you need any more details.


Puthirak OM
Replied On November 13, 2009 09:33 AM

Hi Ganesan,

Thank you for your quick reply.

It works. But now i've encoutered another problem.
It seems that some color are not exported.

I've modified your project to intertwined a light gray line
with the light sky blue line:

if (e.Cell.RowIndex % 2 == 0)
e.Style.Background = Brushes.LightSkyBlue;
e.Style.Background = new SolidColorBrush(Color.FromArgb(0xFF,
0xEB, 0xEB, 0xEB));

The light gray line are not exported.

Reportive SA


Ganesan K [Syncfusion]
Replied On November 21, 2009 05:25 AM

Hi Puthirak,

Thanks for your interest.

Sorry for the delay in getting back to you. I got some details from XLSIO team regarding supporting colors.

For now, we only support known colors in exporting the grid to xls. We will add the unknown colors exporting feature in our future release.

Please let us know if you need any more details.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.