I downloaded 2266 SR and it solved part of this problem. But if icon is not in visible area of grid, it doesn't export to Excel as it is null in CellControl.

I have attached sample solution. Use "Load" button to load sample data and "Excel" to export it. The code working with exporting icon is placed to WriteDataRow function.

Hello Sergey,

Thank you for the provided code but it is not enough to reproduce your scenario. It seems that some methods and properties’ declarations are missing. Is there any reason because of which you are not able to attach your isolated sample application?

Looking forward to hearing from you.

We use the following code to export icons to MS Excel

foreach (Column column in this.grid.Columns.AllVisibleChildColumns)
            {
                var conditionalFormattingCell = row.Cells[column] as ConditionalFormattingCell;
                if (conditionalFormattingCell != null)
                {
                    ConditionalFormattingCellControl cellControl = conditionalFormattingCell.Control as ConditionalFormattingCellControl;
                    if (cellControl != null && cellControl.Icon != null)
                    {
                        BitmapImage image = new BitmapImage();
                        image.CreateOptions = BitmapCreateOptions.None;
                        image.UriSource = ((cellControl.Icon.LoadContent() as Image).Source as BitmapImage).UriSource;
                        WriteableBitmap writeableBitmap = new WriteableBitmap(image);
                        WorksheetShape worksheetShape = new WorksheetImage(writeableBitmap, new PngImageEncoder(), null);
                        worksheetShape.PositioningMode = ShapePositioningMode.MoveWithCells;
                        WorksheetCell cell = sheet.Rows[startRow].Cells[currentColumn + startColumn];
                        worksheetShape.TopLeftCornerCell = cell;
                        worksheetShape.TopLeftCornerPosition = new Point(0.0F, 0.0F);
                        worksheetShape.BottomRightCornerCell = cell;
                        worksheetShape.BottomRightCornerPosition = new Point(33, 40);
                        workSheet.Shapes.Add(worksheetShape);
                    }
                }
                this.SetCellValue(sheet.Rows[startRow].Cells[currentColumn + startColumn], row.Cells[column] as Cell);
                currentColumn++;
            }