We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

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.
Live Chat Icon For mobile
Up arrow icon