Export RadGridview to Excel with variable image sizes (adjusting cell sizes)

UPDATE:  It seems that using "ExportVisualSettings = true" is a good solution in ordinary tables (without image column) but unfortunately NOT works correctly on tables with grouped data (and image columns). The location of images (relative to their cells) are not calculated correctly in excel when there is some grouping...

What should i do?

Thanks

Hello Pin,

As you noticed the ExportVisualSettings property of GridViewSpreadExport controls whether the visual settings and sizes are exported to the excel workbook.

Thanks for the detailed description, which helped me reproduce the problem you are facing. When the image column is exported in a non-grouped grid - the alignment of images in excel cells is correct, but when the grid is grouped the image positioning is not correct. I have logged the issue on our feedback portal, here: RadGridView: Export to excel does not position images correctly when grid is grouped. I have also updated your Telerik points for the report.

As a workaround, if you need to handle the event, you can subscribe to the WorkbookCreated event of SpreadExportRenderer and adjust the position of the image, which is illustrated in the code below:

private void Renderer_WorkbookCreated(object sender, WorkbookCreatedEventArgs e)
{
    if (this.gridView.GroupDescriptors.Count == 0)
    {
        return;
    }

    foreach (var imageShape in e.Workbook.ActiveWorksheet.Shapes)
    {
        double cellWidth = e.Workbook.ActiveWorksheet.Columns[imageShape.CellIndex.ColumnIndex].GetWidth().Value.Value;
        double imageWidth = imageShape.Width;
        
        imageShape.OffsetX = (cellWidth - imageWidth) / 2;
    }
}

Here is the result on my end after the applied workaround:

I hope this helps. Let me know if you need further assistance.

Regards,
Todor Vyagov
Progress Telerik