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.

Open excel file with links

Thread ID:

Created:

Updated:

Platform:

Replies:

24545 Feb 7,2005 05:57 AM Feb 11,2005 09:54 AM Windows Forms 3
loading
Tags: XlsIO
Thierry Vessereau
Asked On February 7, 2005 05:57 AM

Hello I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. Thanks Thierry

Administrator [Syncfusion]
Replied On February 9, 2005 09:37 AM

Hi Thierry, Would it be possible to send the file to me at stephenj @ syncfusion.com . I dont think that the links are getting refreshed during file open. What is the size of the file that you are trying to open?. Thanks, Stephen. >Hello > >I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. > >Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. > >Thanks >Thierry

Thierry Vessereau
Replied On February 10, 2005 04:21 AM

Hi Stephen Unfortunately I can not send you the file because it contains sensitive data. The size of the file is around 2M and contains around 15 worksheets. But I need only a few data from this file (around 1000 cells) It takes however 3-4 minutes to open with the method ExcelUtils.Open(). I dont understand why it takes so long. With an application written in MS/Access I need only a few seconds to access the data. I have the idea now that all the data in the Excel file may be readen with the method Open()? Is it true? If yes, is there an other way to read an excel file? Thanks a lot Thierry >Hi Thierry, > >Would it be possible to send the file to me at > >stephenj @ syncfusion.com . I dont think that the links are getting refreshed during file open. What is the size of the file that you are trying to open?. > >Thanks, > >Stephen. > >>Hello >> >>I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. >> >>Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. >> >>Thanks >>Thierry

Administrator [Syncfusion]
Replied On February 11, 2005 09:54 AM

Hi Thierry, I am afraid, there is no other way to read specific information, ExcelRW reads and parses the whole file with formatting during the read process and populates the complete object model, so there is no way to avoid it. This is possibly a general performance issues with ExcelRW in handling some data in your spreadsheet. However, we are aware of this issue and are working on rectifying it based on sample spreadsheets sent by other customers. We expect to have a build in three weeks time that would address these performance issues with large files. Thank you for your patience. Best regards, Stephen. > >Hi Stephen > >Unfortunately I can not send you the file because it contains sensitive data. > >The size of the file is around 2M and contains around 15 worksheets. But I need only a few data from this file (around 1000 cells) > >It takes however 3-4 minutes to open with the method ExcelUtils.Open(). > >I dont understand why it takes so long. With an application written in MS/Access I need only a few seconds to access the data. > >I have the idea now that all the data in the Excel file may be readen with the method Open()? Is it true? If yes, is there an other way to read an excel file? > >Thanks a lot >Thierry > >>Hi Thierry, >> >>Would it be possible to send the file to me at >> >>stephenj @ syncfusion.com . I dont think that the links are getting refreshed during file open. What is the size of the file that you are trying to open?. >> >>Thanks, >> >>Stephen. >> >>>Hello >>> >>>I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. >>> >>>Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. >>> >>>Thanks >>>Thierry

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.

;