Exporting only filtered data from GridView to Excel using XLSIO

[Administrator]

Hi,

Is there an easy way to export data to Excel from a GridGroupingControl after the user does filtering on a column or columns.

Please attach any sample if possible.

Thanks!!

[Administrator]

Hi Rekha,

The Excel Export ( \Syncfusion\Essential Studio\4.4.0.49\Windows\Grid.Grouping.Windows\Samples\Serialization\Excel Export )sample demonstrates the conversion of contents in a GridGroupingControl to an xls file. The Exporting of a GridGroupingControl has two options: one converts the entire contents in the grid while the other converts only the visible contents in the grid(only filtered records).

The XlsIO libraries are used to convert the grid contents to excel. The dlls that these depend on are Syncfusion.XlsIO.Base and Syncfusion.GridConverter.Windows.

Syncfusion.GroupingGridExcelConverter.GroupingGridExcelConverterControl converter = new
Syncfusion.GroupingGridExcelConverter.GroupingGridExcelConverterControl();
converter.GroupingGridToExcel(this.gridGroupingControl1, FileName,Syncfusion.GridExcelConverter.ConverterOptions.Default);

The above code converts the entire contents in the grid. The code to export the visible or expanded records or groups alone is given below.

converter.GroupingGridToExcel(this.gridGroupingControl1, FileName, Syncfusion.GridExcelConverter.ConverterOptions.Visible);

Here is a sample.
Excel Export.zip

Best regards,
Haneef

[Administrator]

Hi Haneef,

Thanks for your quick response!

Is it possible to turn the autofilter ON in the Excel spreadsheet after the export of filtered data?

Thanks!