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;
        }
    }

Hi Eric,

I have a wdg and change the backcolor and font of each row according to a cell that can contain green and red, so you can change 1st row green backcolor, 2nd and 3rd red, 4rd green again, 5th red...etc.

My WebExcelExporter won't export the styles.

Is it possible you provide the same example as above but with each row with a different colour according to a condition?.

If I handle the rowExported event on the webexcelexporter I can't get rid of the annoying pattern, and if I set it to solid then the line becomes black!, so I wonder if I can avoid using the row ExportedEvent and just export exactly as what I see on the wdg.

Many thanks,

Federico.