There is no Export to Excel option in datagrid 2 so you need to make an customized export excel option like this for the respective data grid Source.
Hi Megha George,
This feature does not seem to be included. You might have to fall back to the excel export module, but achieving the same functionality will be an effort – the export to excel functionality that is integrated to the standard data grid exports exactly what you see – if you filtered your list, the exported data is also filtered accordingly. You might have to use a custom filtering which passes the result list to the excel export..
I think you can use ‘Saved attribute’ setting in a filter to store the last value. Then create a custom export logic to generate excel file based on stored values
This widget needs a lot of development to handle selection processes.