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.
Unfortunately, activation email could not send to your email. Please try again.

Import data from an opened excel file

Thread ID:

Created:

Updated:

Platform:

Replies:

44187 May 16,2006 10:39 AM May 18,2006 12:24 PM Windows Forms 1
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On May 16, 2006 10:39 AM

Hi, I can import data from excel without problem, but if the excel file is already opened in Excel, it throws me an exception. Could you please tell me how can i do that, now i have to close the file in excel before opening it and importing data from the file, Thanks in advance

Administrator [Syncfusion]
Replied On May 18, 2006 12:24 PM

Hi, Sorry for the delay in getting back to you. 1) Please refer to this thread for a possible workaround http://www.syncfusion.com/Support/forums/message.aspx?MessageID=35645 2) The upcoming version 4.2 has a inbuilt method for opening a file already open by MS Excel IWorkbook myWorkbook = excelEngine.Excel.Workbooks.OpenReadOnly("Template.xls"); Please let me know if you have any questions. Best regards, Stephen. >Hi, > >I can import data from excel without problem, but if >the excel file is already opened in Excel, it throws me an exception. >Could you please tell me how can i do that, now i have to close the file in excel before opening it and importing data from the file, > >Thanks in advance >

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.

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.

;