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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Virtual Grid & XLSIO

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 [Syncfusion]
Replied On November 13, 2009 09:14 AM UTC

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
Replied On November 13, 2009 02:33 PM UTC

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 [Syncfusion]
Replied On November 21, 2009 10:25 AM UTC

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

CONFIRMATION

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.

Warning Icon 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.Close Icon

;