Angel,

Thanks.  I'm using a WebDataGrid. 

<ig:WebDataGrid ID="wdg_Report" Visible="true" Height="200px" Width="800px" ItemCssClass="NewItemClass" HeaderCaptionCssClass="HeaderCaptionClass" AutoGenerateColumns="false" runat="server">

<

ig:WebExcelExporter runat="server" ID="wee_WebExcelExporter" ExportMode="Download" DownloadName="View_Accounts" EnableStylesExport="true" />

The ItemCssClass and HeaderCaptionCssClass styles are not being carried over to the Exported Spreadsheet.  Do you know why this might be?

Actually, I got it to work but handling the RowExported event, setting the fore and back pattern to the same gets rid of the pattern and sets the desired colour, and disabling export styles of the exporter, but the drawback is that it involves more code, so the question is.... How can I achieve the same just by setting the OnInitializeRow of the webdatagrid).

here is my InitializeRow of the wdg:

 protected void wdg_OnInitializeRow(object sender, Infragistics.Web.UI.GridControls.RowEventArgs e)
    {
    
        if (e.Row.Items[1].Value.ToString() == "Green")
        {

            int intTemp = e.Row.Index;
            Style rowStyle = new Style();
            rowStyle.BackColor = System.Drawing.Color.DarkGreen;
            rowStyle.ForeColor = System.Drawing.Color.White;
            rowStyle.Font.Bold = true;
            e.Row.CssClass = Infragistics.Web.UI.Framework.AppSettings.AppStylingManager.CssRegistry.Add(rowStyle, "TBODY TR.{0} TD");
           
        }
        else
        {
            int intTemp = e.Row.Index;
            Style rowStyle = new Style();
            rowStyle.BackColor = System.Drawing.Color.DarkRed;
            rowStyle.ForeColor = System.Drawing.Color.White;
            rowStyle.Font.Italic = true;
            e.Row.CssClass = Infragistics.Web.UI.Framework.AppSettings.AppStylingManager.CssRegistry.Add(rowStyle, "TBODY TR.{0} TD");
        }
    }

By the way, this is the code (the long way)just in case it helps someone:

ASP
<ig:WebExcelExporter  ID="ExporterXL"
                    ExportMode="Download" runat="server"
                    OnRowExported="ExporterXL_RowExported" EnableStylesExport="False">
                                        </ig:WebExcelExporter>

c#
    protected void ExporterXL_RowExported(object sender,   ExcelRowExportedEventArgs e)
    {
        if (e.IsHeaderRow == true)
        {
            e.WorksheetRow.CellFormat.FillPatternBackgroundColor = System.Drawing.Color.LightBlue;
            e.WorksheetRow.CellFormat.FillPatternForegroundColor = System.Drawing.Color.LightBlue;
            e.WorksheetRow.CellFormat.Font.Bold = Infragistics.Excel.ExcelDefaultableBoolean.True;
            e.WorksheetRow.CellFormat.Font.Color = System.Drawing.Color.White;
            return;
        }
          
        if (e.WorksheetRow.Cells[1].Value.ToString() == "Green")
        {
            e.WorksheetRow.CellFormat.FillPatternBackgroundColor = System.Drawing.Color.DarkGreen;
            e.WorksheetRow.CellFormat.FillPatternForegroundColor = System.Drawing.Color.DarkGreen;
            e.WorksheetRow.CellFormat.Font.Bold = Infragistics.Excel.ExcelDefaultableBoolean.True;
            e.WorksheetRow.CellFormat.Font.Color = System.Drawing.Color.White;
          
        }
        else
        {
            e.WorksheetRow.CellFormat.FillPatternBackgroundColor = System.Drawing.Color.DarkRed;
            e.WorksheetRow.CellFormat.FillPatternForegroundColor = System.Drawing.Color.DarkRed;
            e.WorksheetRow.CellFormat.Font.Italic = Infragistics.Excel.ExcelDefaultableBoolean.True;
            e.WorksheetRow.CellFormat.Font.Color = System.Drawing.Color.White;
        }
    }