load excel to grid grouping control

How do I load Excel spreadsheet data into a GridGroupingControl? So far I'm able to only do the reverse (download the entire grid) using Syncfusion.GroupingGridExcelConverter.GroupingGridExcelConverterControl. I'd also like refine the latter and dowload only selected rows.

Hi Dimitri,

Sorry for the inconvenience caused. Currently this feature is not supported in GroupingGrid. But you can do this by using the GridControl/GridDataBoundcontrol, Please refer to the attached sample for more details.

Sample : http://www.syncfusion.com/Support/user/uploads/ExcelImport_da577b05.zip

Thanks for your patience.

Best Regards,
Haneef

Thanks Haneef,
Actually, I was able to adapt the following:

groupGridControlExcel1.DataSource = sheet.ExportDataTable(sheet.UsedRange,ExcelExportDataTableOptions.ColumnNames);



>Hi Dimitri,

Sorry for the inconvenience caused. Currently this feature is not supported in GroupingGrid. But you can do this by using the GridControl/GridDataBoundcontrol, Please refer to the attached sample for more details.

Sample : http://www.syncfusion.com/Support/user/uploads/ExcelImport_da577b05.zip

Thanks for your patience.

Best Regards,
Haneef