Import data from excel to GDBG

[Hyung-Jin Lee]

Hello.
There are many articles and samples about
moving data from grid to excel.

But I couldn't find sample that moves data
from excel to GridDataBoundGrid.

I use below code, but it didn't work.

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
gecc.ExcelToGrid(@"D:\ABC\abc.xls", this.gridDataBoundGrid1.Model);


Please, let me know how I do it.
Thank you.

[Nirmal Raja]

Hi Chin,

Thank you for your interest in Syncfusion product.

The Excel import is done using a class called ExcelEngine.
A Workbook will be created for the application using IApplication, and the workbook holds all the WorkSheet of the Excel.
So the collection is maintained using WorkSheets object, to retrive a specific sheet of the ExcelEngine it can be retrieved from the WorkSheets collection.

Please refer the below samples:
GDBGImportExcel

Let me know if you have any queries.

Regards,
Nirmal

[Hyung-Jin Lee]

Hello. Nirmal
I solved the problem with your help.
Thank you very much.