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.

2 Replies

AD Administrator Syncfusion Team November 21, 2006 09:24 AM UTC

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


AD Administrator Syncfusion Team November 21, 2006 07:09 PM UTC

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

Loader.
Up arrow icon