How to export to excel filtered data in kendo grid

[Chamal]

How to export to excel filtered data in kendo grid using angular 8 

[Hetali]

Hello Aruna,

We have a dedicated article to Export Specific Data in the Kendo UI Grid. Using the given example, please make the following changes to export filtered data:

<kendo-grid
  [group]="group"
  [filter]="filter"
  [filterable]="true"
  (filterChange)="filterChange($event)">
</kendo-grid>

public group: any[] = [];
public filter: CompositeFilterDescriptor;

public allData(): ExcelExportData {
  const result: ExcelExportData =  {
    data: process(products, { filter: this.filter, sort: [{ field: 'ProductID', dir: 'asc' }] }).data,
    group: this.group
  };
  return result;
}

public filterChange(filter: CompositeFilterDescriptor): void {
  this.filter = filter;
  this.products = filterBy(products, filter);
}

In this StackBlitz example, the filtered data in the Kendo UI Grid is exported in an Excel file.

I hope this helps. Please let me know if I can further assist you.

Regards,
Hetali
Progress Telerik

[Chamal]

Thank you...