Excel export only FilteredRecords

[Ruben]

Hi,

t is possible to export only the filtered records, if I have a table with 50,000 rows when calling Grid.Table.ExpandAllRecords (), it expands all the records, but I only need to expand and export the filtered.

A "solution"

 foreach (Record r in DgPedidos.Grid.Table.FilteredRecords)

                {

                    r.IsExpanded = true;

                    if (r != null)

                    {

                        r.NestedTables[0].IsExpanded = true;

                        foreach (Record rec in r.NestedTables[0].Records)

                        {

                            if (rec != null)

                            {

                                if (rec.NestedTables.Count > 0)

                                    rec.NestedTables[0].IsExpanded = false;

                            }

                        }

                    }

                }

Thanks

[Balamurugan Thirumalaikumar]

Hi Ruben, 

Thank you for contacting Syncfusion support. 

We have checked your query “Excel export only FilteredRecords” at our end. In order to export the GridGrouping control with filtered data’s we have prepared the simple sample for your reference. You can refer the following sample link. 

Sample link - https://www.syncfusion.com/downloads/support/directtrac/general/ze/CS1321051468.zip 

Please let us know if you would require any other assistance. we will be always happy to assist you. 

Thanks & Regards, 

Balamurugan Thirumalaikumar