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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Import data from excel to GDBG

Thread ID:

Created:

Updated:

Platform:

Replies:

77852 Nov 19,2008 09:13 AM UTC Nov 20,2008 11:06 AM UTC WinForms 2
loading
Tags: GridControl
Hyung-Jin Lee
Asked On November 19, 2008 09:13 AM UTC

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 [Syncfusion]
Replied On November 20, 2008 08:48 AM UTC

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
Replied On November 20, 2008 11:06 AM UTC

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




CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;