Virtual Grid & XLSIO

[Puthirak OM]

Hi,

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 7.4.0.20

Thanks,
P.OM
Reportive SA




VirtualGrid_ExportToExcel_fb609a4e.zip

[Ganesan K]

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.

http://www.syncfusion.com/uploads/redirect.aspx?file=VG-ExportToExcel_cd09b4d9.zip&team=development

Please let us know if you need any more details.

Thanks
Ganesan

[Puthirak OM]

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;
else
e.Style.Background = new SolidColorBrush(Color.FromArgb(0xFF,
0xEB, 0xEB, 0xEB));

The light gray line are not exported.

Thanks,
P.OM
Reportive SA




VG-ExportToExcel-color-problem_7a867bb9.zip

[Ganesan K]

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.

Thanks
Ganesan