Imports xls file into grid

[Lecomte]

Hi,

Can someone gives me de code line to fill a gridcontrol with an excel file.

Thank

Beginner must live and learn !!!!!

[haneefm]

Hi Lecomte,

An excel sheet can also be imported to the GridControl using the ExcelToGrid method. The code to import the xls file is given below.

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
gecc.ExcelToGrid( openFileDialog.FileName, this.gridControl1.Model);

Also refer to the ExcelExport_GridControl browser sample for more details.
C:\Program Files\Syncfusion\Essential Studio\4.4.0.49\Windows\Grid.Windows\Samples\Serialization\ExcelExport_GridControl

Best regards,
Haneef