convert to excel a selectrecords

[alvin]

hi,
i'm new on syncfusion and i search convert to excel : selectedrecords from gridgrouping control.

Thanks for help in advance :)

[Mahendran]

Hi Alvin,

Thanks for your interest in Syncfusion Products.

In GridGroupingControl to convert the selected records to excel you need handle the ExportElement event handler with respective code. We have created a sample and attached below for your reference in which this requirement has been achieved.

Code snippet [C #]

private void button1_Click(object sender, EventArgs e)
        {
            if (this.gridGroupingControl1.Table.SelectedRecords.Count > 0)
            {
                ExcelEngine xl = new ExcelEngine();
                IApplication app = xl.Excel;
                app.DefaultVersion = ExcelVersion.Excel2010 ;
                IWorkbook workBook = app.Workbooks.Create();
                IWorksheet sheet = workBook.Worksheets[0];
                GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl();
                converter.ExportElement += new GroupingGridExcelConverterControl.GridExportElementEventHandler(converter_ExportElement);
                converter.GroupingGridToExcel(this.gridGroupingControl1 ,sheet, Syncfusion.GridExcelConverter.ConverterOptions.Default);
                workBook.SaveAs("Test.xlsx");
            }
        }

        void converter_ExportElement(object sender, GridExportElementEventArgs e)
        {
            if (e.Element.Kind == DisplayElementKind.Record && !this.gridGroupingControl1.Table.SelectedRecords.Contains(e.Element.GetRecord()))
            {
                e.Cancel = true;
            }
        }

Here is a sample for your reference

http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=SampleForExcel787466356.zip

Please let me know if you have any concerns.

Regards,
R.Mahendran