load excel to grid grouping control

[Dimitri Kutuzov]

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.

[Administrator]

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

[Administrator]

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