Hi,
I am exporting a XamDataGrid's data using DataPresenterExcelExporter. It is working fine but in the excel sheet that is generated, I want a column filter to be applied so that the data is grouped by that column's values. Have also attached the image of what excel property I am referring to.
I'm actually hoping to achieve similar functionality. I don't want to filter the results, but I want to add the "filter" option to the individual column headers. I typically achieve this by selecting the row I want and hitting "Filter" on the Excel Data tab.