styles not reflecting in ElementExporting event

[Prithvi]

Hi,

when the ext is xml and format is ExportFormat.ExcelML, stlyes written in ElementExporting are not getting reflected in the Excel file.


public void rtlvForExport_ElementExporting(object sender, GridViewElementExportingEventArgs e)
{
if (e.Element == ExportElement.Cell
&& e.Value != null

 

&& e.Value.GetType() ==

 

this.SModel.RecordClassType)

 

{e.Value =

 

"";}
if (e.Element == ExportElement.HeaderCell)

 

{e.Background =

 

Colors.LightGray;

 

e.Foreground =

 

Colors.Black;

 

e.FontSize = 15;

e.FontWeight =

 

FontWeights.Bold;
}

 

 

 

else if ((e.Element == ExportElement.Cell) && (e.Value != null))

 

{e.TextAlignment =

 

TextAlignment.Center;

 

e.TextAlignment =

 

TextAlignment.Center; ;

 

e.VerticalAlignment =

 

VerticalAlignment.Center;
}

 

 

 

else if ((e.Element == ExportElement.Cell) && (e.Value.Equals("MANUFACTURED")))

 

{

e.Background =

 

Colors.Magenta;

 

e.Foreground =

 

Colors.Black;

 

}

}

[Prithvi]

Please help me ASAP

Thanks,
Prithvi

[Dimitrina]

Hello,

 You should use the ExportFormat.Html to get the styles applied.

Kind regards,
Didie
the Telerik team

[Gopinath]

thanks a lot it solved my problem too!!!