Thanks, but this is not what my question was about.

My question was how to read the cells/rows background brush from the grid?

Once I know the color, then I can use FormatString to pass that color. But I need to know that color first.

foreach (var item in xamDataGrid.DataSource)

 {

var dataRecord = xamDataGrid.GetRecordFromDataItem(item, false);

var color = dataRecord.Cells[1].DataPresenter.Background;

}

HI,

 I am just following up on this forum thread.

 Please let me know if you require further assistance.

 Sincerely,
 Matt
 Developer Support Engineer

Thanks, but it does not work - always getting #FFFFFFFF value.

Background is set with DataTriggers for

FieldLayoutSettings.DataRecordCellAreaStyle

Any other ideas?

HI,

 Try this code

 foreach (var item in xamDataGrid1.DataSource)
            {

                var Record = xamDataGrid1.GetRecordFromDataItem(item, false);//

                DataRecord dr = Record as DataRecord;

                foreach (Cell c in dr.Cells)
                {
                    
                
                    CellValuePresenter cvp1 = CellValuePresenter.FromRecordAndField(dr, c.Field);
                    if (cvp1 != null)
                    {
                        var color = cvp1.Background;
                    }
                }
              
 Sincerely,
 Matt  Developer Support Engineer

Thanks, I have tried this code:

It does pickup the color if CellValuePresenter style was set;

It does not pickup if DataAreaCellPresenter was set.

Also seems like only visible rows are exported with colors - all rows which were invisible are exported without colors.

Hi Infragistics Team,

I have a similar situation where I need to preserve the color-coding on exporting to excel.

The color-coding is dynamic and here's how it is done:

dr.Cells["Column1"].EditorStyle = xamDataGrid1.TryFindResource("BackColorRedTextStyle") as Style;

I did look at the sample in XamFeatureBrowser, but it is being set at design time and not run time. So, not much of help.

I used the sample code snippet above to loop through the DataRecords and Cells to retrieve the Style and corresponding Setters.

But I am at a loss later on how to set the FormatString to preserve the style. Any sample code would be highly helpful.

Thanks.

Thanks. Might have some questions later on.

HI,

 I am following up on this forum thread.

 Do you need further assistance regarding this issue?.

 Sincerely,
 Matt
 Developer Support Engineer