Error exporting to excel

[Werther]

[Werther]

Found the solution with this post:

Expanding Entities and Export

Hi, I have three tables: Purchase, Product & ProductType Every Purchase has a Product (telling me which product was purchased) and each Product has a ProductType (telling me of which type the product is). I have a grid showing the purchases of a customer and in the columns I show the product name and product type name. By using $expand I can easily include the Product and ProductType entities. Now I also want to use the Export function (to CSV and Excel). The problem is that the selected co…

[Amer]

Hello dear Radzen team,
I have the same problem in one of my projects, two properties:
Property="Employee.FullName"
Property="Student.FullName"
are showing in the grid easily using expand, while causing the same AmbiguousMatchException when exporting to Excel.

In my export function I see:

{
	Filter = $@"{(string.IsNullOrEmpty(grid0.Query.Filter) ? "true" : grid0.Query.Filter)}",
	OrderBy = $"{grid0.Query.OrderBy}",
	Expand = "Employee,Student",
	Select = string.Join(",", grid0.ColumnsCollection.Where(c => c.GetVisible()).Select(c => c.Property))
}, ....

Where it uses the "Property" name for the export, so here, where should I use "aliases/as" like what is mentioned in the linked answer ?

[enchev]

@Amer

Select = string.Join(",", grid0.ColumnsCollection.Where(c => c.GetVisible()).Select(c => c.Property))

You should extend this to use aliases instead plain property names.

[Amer]

It's what I understood from the first answer, which means - if I'm not mistaken - that I have to write the field names directly, something like:
Select = "ID,Employee.ID as EmployeeID,Employee.FullName as EmployeeName,Employee.Phone as EmployeePhone,Student.FullName as StudentName,Student.Phone as StudentPhone,Course.StartDate,Course.EndDate, .... , ....... (and many others)"
But in this case, I will lose the visibility control of the columns (picking on demand), which is helpful for my clients due to the large number of columns in this grid (and most other grids of the project), where I only show few columns and let the user choose what he needs to view and export.

[enchev]

I’m not suggesting to hardcode the columns. You can rework the Select(), I've updated our demo:

[Amer]

Oh, I feel dumb for not thinking of that!
Many thanks

[Amer]

And also add && c.Property != null so it will skip any column without a property name, like the "Delete Button" column (in case it was left visible on Export).

Select  = string.Join(",", grid0.ColumnsCollection
				.Where(c => c.GetVisible() && c.Property != null)
				.Select(c => c.Property.Contains(".") ? $"{c.Property} as {c.Property.Replace(".", "_")}" : c.Property))