Good morning,
when I export a DataGrid to Excel, the exported Excelsheet only shows the value of the ForeignKey-Column:
I expected that there will also be shown the "resolved" Value from the target table (as shown in my DataGrid):
How can I correct that?
Thanks in advance,
Martin
im also searching a solution for this.
Thomas
At the moment this is not supported
Too bad. Then the Excel Export is useless for me. I have FK's in almost every Datagarid.
Perhaps sometimes the Excel Export exports the Datagrid "as it is".
Thomas
The export controller code is part of the generated application and you can modify it in the way you want.
Ah! Yes. And then put it on the ignore list. Ok
Thanks
Thomas
@Thomas, let me know if you find a clean way to make this happen, I'm going to want this too.
Until then, I guess I'll have to stick with the SSRS component reports...
Slosuenos
@Thomas, I'm thinking that you could modify the export click event, add an Execute C# that joins together the main table (to maintain any sorting & filtering performed on the datagrid) with related tables with Linq, and sets the results to a new property. Then export the new property.
I'll see if you come up with anything before even trying this, as my Linq stinks and writing the query will be painful...
Slosuenos
@SloSuenos, i will post here if i find a way to get the desired result. I will not use the Excel Export if i must do or modify each export programatically. Too much effort...
Only if i find a way that works for all exports. That means for sure to know whats defined in the datagrid and so on. Not easy. And not one of my higher priorities. Our App is in the beginning and there are so much things that are more important 
Thomas
You will be able to export lookup columns in Blazor application using latest Radzen. We will check if we can enable the same for Angular.
HI, are there any updates on this topic?
Nacho
Yes, export of foreign keys was enabled two years ago using dot notation in $select parameter.